On 23/09/2021 14:37, Clive Swan wrote:
> Greetings,
>
> I have two separate queries that work individually, returning a count
> from each column.
>
> I want to subtract New(COUNT) from Old(Count)
>
> I get an error when trying to run UNION?
At a quick guess, you'll need to move the subtraction outside the two
subqueries - stuff inside either query can't see anything in the other one.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie