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

Recommended Answers

All 4 Replies

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: Thanks to recovering my code +1
commented: yes +1
commented: Nice +3

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.