Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-05 : 10:48:39
|
| sgb writes "If I have four tables: CUSTOMER, INVOICE, COMPUTER, InvoiceLineItems and want to find the type of computer that were never bought by customers in a specific state like PA. How do I express this in queries?I was thinking to use not exists or not in but my codes are not working right.Thanks" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-05 : 10:55:52
|
| Show us what you have got till now and we can sort out the problem.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2007-03-05 : 10:56:29
|
| Give me the Cols from each tableVic |
|
|
|
|
|
|
sql queries join tables