Jump to content

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


fansa

Recommended Posts

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.