468,107 Members | 1,311 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

Query Problem

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
Nov 13 '05 #1
1 1815
use the find Unmatched query wizard...

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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Adam Louis | last post: by
6 posts views Thread by Martin Lacoste | last post: by
11 posts views Thread by Andy_Khosravi | last post: by
4 posts views Thread by Stan | last post: by
2 posts views Thread by existential.philosophy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.