ID items in one table, but not another table (Access 2003)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Example:
Two Tables (Table 1 and Table 2)
Field = ItemNumber (Primary Key on Table 1; Foreign Key on Table 2)

How would I identify all instances where the ItemNumber is populated on
Table 1, but is Null on Table 2?
 
SELECT Table1.*
FROM Table1 LEFT JOIN Table2
ON Table1.ItemNumber = Table2.ItemNumber
WHERE Table2.ItemNumber IS NULL;

Ken Sheridan
Stafford, England
 
Back
Top