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 |
|
samymelbourne
Starting Member
1 Post |
 Posted - 2004-10-27 : 08:24:11
|
| Hi All,I have a problem trying to create a query that will obtain those records (from two tables) which are not in each others tableIE) T1--------------- T2---------------- QUERY RESULT ID | Description ID | Description ID | Description 1 yellow 0 white 0 white 2 red 1 yellow 5 blue 5 blue 2 red Any help is appreciated in advance.. I have tried updates but it doesn't work..I am sure there's has to be an easy way.. thank you! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-27 : 12:02:37
|
will this work?select t1.*from t1 left join t2 on t1.id = t2.idwhere t2.id is nullGo with the flow & have fun! Else fight the flow  |
 |
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2004-11-08 : 14:50:35
|
| Uhm,Silly question, but why not just use an unmatched query? Find all records from Table A that are not in Table B sort of deal. |
|
|
|
|
|
|
help for opposite of sql inner join in access