Subtracting lists with query

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I have 2 queries :
A. large list of names with an unique id
B. small list of names with an unique id

The names and id's in both queries come from the same table.

I want to have a list with the names of A which are not in the B-list.

How do i do that ?
 
You might try using the "Find Unmatched Query Wizard", which you can select
from when you create a new query.

In general, the SQL one way of doing this kind of thing might look something
like this:

SELECT
A.*
FROM
A
LEFT JOIN
B
ON
A.[Related Field] = B.[Related Field]
WHERE
B.[Related Field] Is Null
 
Back
Top