|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 14th, 2008, 09:26 PM
|
|||
|
|||
|
Sql query help not exists
Hello,
I have two tables A & B. table A has a column for example Color. There are some rows in this table that have value '-2' for Column color. There is another table B. Two tables can be joined by column called 'Sample'. I am trying to find out a way to fetch records that have value of -2 in table A for column Color but these records are NOT IN table B. I'd appreciate if someone could help me with this a little. I tried something like this Code:
select * from table A where A.Color = '-2' and not exists (select * from table B); but that doesnt work 
|
|
#2
July 14th, 2008, 09:56 PM
|
||||
|
||||
|
Code:
SELECT tableA.*
FROM tableA
LEFT OUTER
JOIN tableB
ON tableB.Sample = tableA.Sample
WHERE tableA.Color = '-2'
AND tableB.Sample IS NULL
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Sql query help not exists |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
