Problem checking values 1

[morfasie]

Hi

I have a table test
Number
|1 |
|2 |
|3 |

and a table test2
Number
|1 |
|2 |

I want a query where the returning result is the 3, because it isn't in both tables.

 

[PHV]

Something like this ?
SELECT * FROM test
WHERE Number NOT IN (SELECT Number FROM test2)
Or this ?
SELECT A.* FROM test A LEFT JOIN test2 B ON A.Number = B.Number
WHERE B.Number IS NULL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244