Query for records that don't match

  • Thread starter Thread starter Simon Abolnar
  • Start date Start date
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
 
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
 
Back
Top