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@xxxxxxxxxxxx
