fansa Posted June 24, 2009 Share Posted June 24, 2009 why my this query select a.jantina,count (d.no_kp), a.kp from pekebun_kecil a, t_permohonan b, t_kedatangan c inner join t_kedatangan d on d.kod_siri=b.pilihan_kursus where a.kp=b.no_kp and b.pilihan_kursus='IKPKPHGP01001007-1-2009' and a.kp=c.no_kp and b.pilihan_kursus=c.kod_siri and d.kod_siri='IKPKPHGP01001007-1-2009' and b.status_proses not in ('Batal','Diganti') appear this error Msg 4104, Level 16, State 1, Line 2 The multi-part identifier "b.pilihan_kursus" could not be bound. Link to comment https://forums.phpfreaks.com/topic/163453-solved-error-the-multi-part-identifier-bpilihan_kursus-could-not-be-bound/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.