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 |
|
aberbotimue
Starting Member
26 Posts |
 Posted - 2009-10-13 : 13:02:53
|
| I'm sure it's a simple one, but I have built a good 15 - 20 queries, and non have done the trick, I am resorting to asking.. I have a table full of items.I have a table full of locations of those items..I want a query that lists all the items in the first table, that arn't in the second..Its that simple, but I can't figure it!!any help would be loved! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
aberbotimue
Starting Member
26 Posts |
Posted - 2009-10-14 : 14:08:39
|
| Thanks Guys.. WOrked like a dream!! and three different versions to choose from!! shows how bad I am at this! couln't eveb get one to work! |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Show items NOT in another table