|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 27th, 2004, 07:35 AM
|
|||
|
|||
|
help for opposite of sql inner join in access
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 table IE) 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!
|
|
#2
October 27th, 2004, 07:54 AM
|
||||
|
||||
|
Code:
select T1.ID
, T1.Description
from T1
left outer
join T2
on T1.Description
= T2.Description
where T2.Description is null
union all
select T2.ID
, T2.Description
from T2
left outer
join T1
on T2.Description
= T1.Description
where T1.Description is null
|
|
#3
October 27th, 2004, 08:04 AM
|
|||
|
|||
|
THANK YOU!!! spent most of yesterday's afternoon trying to break this..
 Quote:
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > help for opposite of sql inner join in access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
