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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BSA Dave - 20 Mar 2006 22:38 GMT

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?

Reply to this Message

Ken Sheridan - 20 Mar 2006 23:32 GMT

SELECT Table1.*
FROM Table1 LEFT JOIN Table2
ON Table1.ItemNumber = Table2.ItemNumber
WHERE Table2.ItemNumber IS NULL;

Ken Sheridan
Stafford, England

> 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?

Reply to this Message