Fields that do not exist

[jeroldqc]

Hi guys!

How do I create a query/select wherein I only need field(s) from Table 2 that do not exist in Table1?

Table1
id field
-- -----
1 A
2 B
3 C


Table2
id field
-- -----
1 A
4 D
5 E

I need this result:
id field
-- -----
4 D
5 E

 

[ByteMyzer]

Try:
[tt]
SELECT * FROM Table2 WHERE NOT EXISTS (SELECT * FROM Table1 WHERE Table1.id=Table2.id;
[/TT]

 

[PHV]

You may try this:
SELECT T2.* FROM Table2 T2 LEFT JOIN Table1 T1
ON T2.Field = T1.Field
WHERE T1.Field 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