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 |
|
knudmt
Starting Member
12 Posts |
 Posted - 2012-09-06 : 19:44:52
|
| I have two tablesleftTablename: someNametitle: someTitleRightTablename: someNametitle: someTitleI need every value from the left table and the right table except where the left table (name and title) match the right table (name and title)how can I accomplish this? |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2012-09-07 : 02:42:14
|
| use left join in the query. |
 |
|
|
arpana patil
Starting Member
24 Posts |
Posted - 2012-09-07 : 04:48:29
|
| use left outer join |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-09-07 : 05:25:37
|
read for INTERSECT in BOL, I think it is what you mean...
Too old to Rock'n'Roll too young to die. |
|
|
|
|
|
|
Help with simple query