Exclude recordset that are retrieved by another query

[Guest]

Hi.

I have two queries;

the first list all my records (without duplicates...) is contains four
fields (Type of Modification,Modification id, Modification Reference number,
Number of impacted dwgs)

the Second returns another listing with two fields (Mod id (which
corresponds to the Modification id field from the 1st query) and Number of
Dwgs closed).

I would like to know how to create a 3rd query that will return a trimmed
sorting of the first qry based on the results from the 2nd. I want a listing
of the modifications where the "Number of impacted dwgs" does not equal that
of the "Number of dwgs closed"

Thanks for the help,

Daniel

 

[Michel Walsh]

Hi,


SELECT a.ModificationID
FROM table1 as a INNER JOIN table2 As b
ON a.ModificationID = b.ModificationID AND a.ImpactedDwg <> b.DwgClosed


Hoping it may help,
Vanderghast, Access MVP