sorry if this a very newbie question but what wrong with my code :

select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName
from TBIn,Barang,Supplier
where TBIn.SupCode=Supplier.SupCode and
TBIn.IdBrg=Barang.IdBrg and
TBIn.IdBrg = B002

Please Help,
Best regards...

your code just less single quote sign.

select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier
where TBIn.SupCode=Supplier.SupCode and
TBIn.IdBrg=Barang.IdBrg and
TBIn.IdBrg = [B]'B002'[/B]
commented: Nice +3
commented: yes +1
commented: Thanks to recovering my code +1

hi jx_man thx for reply...
it works. sorry for my mistake...

commented: post again +1

and i maybe will post some thread again, sorry for disturbing you.

you're welcome friend