•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 422,664 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,654 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 523 | Replies: 4 | Solved
![]() |
sorry if this a very newbie question but what wrong with my code :
Please Help,
Best regards...
MSSQL Syntax (Toggle Plain Text)
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...
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation:
Rep Power: 11
Solved Threads: 235
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 *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation:
Rep Power: 11
Solved Threads: 235
you're welcome friend
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
![]() |
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
ajax asp database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development hacker management studio 2005 microsoft msdn news office security software sql sql cache dependency with polling-based invalidation survey vista
- passing values of Select box from JSP to Action class thru form Bean (JSP)
- Need to get rid of startup error: Please select the operating system to start (Windows 9x / Me)
- Program Problem with a select statement to access Data base (C)
- HTML Form not working with IE when lots of select/option boxes included. (HTML and CSS)
- HTML Form not working with IE when lots of select/option boxes included. (Web Browsers)
- Turn Off Display and Select an Animated Character in Search Companion in Windows XP (Windows tips 'n' tweaks)
- please select the operating system to start (Windows NT / 2000 / XP / 2003)
Other Threads in the MS SQL Forum
- Previous Thread: get only ONE row with different fields from same table
- Next Thread: Trigger problem



Linear Mode