[SOLVED] error The multi-part identifier "b.pilihan_kursus" could not be bound.

[fansa]

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.