Query for records that don't match

S

Simon Abolnar

I have two tables:

1. Table1: IDName
Name

2. Table2: IDSubject
IDName
Subject

How would I do query that select only those records from table1 that DON'T
MATCH in Table2 (on IDName)

Thanks for help!

Simon
 
A

Ali

You can use the UnMatched query wizard
or something like

SELECT Table1.IDName
FROM Table1 LEFT JOIN Table2 ON Table1.IDName = Table2.IDName
WHERE Table2.IDName Is Null

HTH
 
Top