subtraction query

[Wim]

Hi all,

I want to create an subtraction query but can't remember
the syntax.

I have two queries where the unique key is "Id".
I want to subtract the "bad" values in the second query
(Q2) from the "global" query (Q1), based on the equal
value of Id in Q1 and Q2.
So if I have e.g. 2000 records in Q1 and 25 in Q2, I want
to have 1975 records in the resulting query, all 25
records from Q2 having "disappeared".

Thanks for helping,

Wim

 

[John Viescas]

SELECT Q1.*
FROM Q1 LEFT JOIN Q2
ON Q1.Id = Q2.Id
WHERE Q2.Id Is Null

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

 

[Wim]

John,

I'll give it a try and let you know the results.