Query Problem

[Chuck Insight]

Hi All,

I have two tables (book and reference) that share a common field, ISBN.

Both tables are supposed to have matching entries.

I need a query that displays records that exist in the book table, but are missing from the reference table.

Thanks very much,
Chuck

[pietlinden@hotmail.com]

Re: Query Problem

use the find Unmatched query wizard...

SELECT Book.ISBN
FROM Book LEFT JOIN Reference ON Book.ISBN=Refer ence.ISBN
WHERE Reference.ISBN IS NULL;