0

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...

2
Contributors
4
Replies
6
Views
9 Years
Discussion Span
Last Post by Jx_Man
3

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]
Votes + Comments
yes
Thanks to recovering my code
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.