RSS Forums RSS
Please support our MS SQL advertiser: Programming Forums
Views: 668 | Replies: 4 | Solved | Thread Tools  Display Modes
Reply
Join Date: Jan 2008
Posts: 37
Reputation: ITKnight is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 1
ITKnight's Avatar
ITKnight ITKnight is offline Offline
Light Poster

select

  #1  
Feb 10th, 2008
sorry if this a very newbie question but what wrong with my code :
  1. select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName
  2. from TBIn,Barang,Supplier
  3. where TBIn.SupCode=Supplier.SupCode and
  4. TBIn.IdBrg=Barang.IdBrg and
  5. TBIn.IdBrg = B002

Please Help,
Best regards...
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,602
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 12
Solved Threads: 239
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: select

  #2  
Feb 10th, 2008
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 = 'B002' 
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Jan 2008
Posts: 37
Reputation: ITKnight is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 1
ITKnight's Avatar
ITKnight ITKnight is offline Offline
Light Poster

Re: select

  #3  
Feb 10th, 2008
hi jx_man thx for reply...
it works. sorry for my mistake...
Reply With Quote  
Join Date: Jan 2008
Posts: 37
Reputation: ITKnight is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 1
ITKnight's Avatar
ITKnight ITKnight is offline Offline
Light Poster

Re: select

  #4  
Feb 10th, 2008
and i maybe will post some thread again, sorry for disturbing you.
Reply With Quote  
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,602
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 12
Solved Threads: 239
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: select

  #5  
Feb 11th, 2008
you're welcome friend
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 6:26 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC