[HELP] Seputar left join, hasil no tidak keluar

misi gan, saya nanya lagi disini. mau tau nih saya abis bikin query yes/no pake left join kenapa yg no nya gak keluar yaa? ini query saya

SELECT a.*, IF(b.id_riwayat_training_fk_detail_view IS NULL, 'No', 'Yes') as status
FROM materi_detail as a
LEFT JOIN training_detail as b ON a.nama_materi = b.nama_materi
WHERE a.id_karyawan = b.id_karyawan
	AND b.id_karyawan = '1'
ORDER BY `a`.`id_karyawan` ASC

nih picnya

sorry gan nge spam, siapa tau ada yg bisa bantu... thankyou