Member Avatar for ITKnight

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
  • 191 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man

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
Member Avatar for ITKnight

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

commented: post again +1
Member Avatar for ITKnight

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

Member Avatar for Jx_Man

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.