Re: Get COUNT results from two different columns - Mailing list pgsql-general

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