subtract two queries

[Leslie]

I have 2 queries that i want to make into one by
subtracting one from the other.
Example:
Query1: select Count(*) AS FROM appl
WHERE appl.APPLICATION_ID In (select application_id from
quote_delivery)
Query2: select count(*) from quote_delivery

I want a count for Query2 - Query1 and I would like this
to all be one query.

Is it possible?

Thanks in advance.

 

[Michel Walsh]

Hi,



SELECT SUM(z)
FROM ( SELECT COUNT(*) As z FROM table1
UNION ALL
SELECT -COUNT(*) FROM table2) As w




Hoping it may help,
Vanderghast, Access MVP