m: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: 23 September 2021 17:45
To: clives...@gmail.com
Cc: pgsql-generallists.postgresql.org
Subject: Re: Get COUNT results from two different columns
On Thu, Sep 23, 2021 at 6:37 AM Clive Swan wrote:
Greetings,
I have two separate queries th
Greetings,
Thanks for the message.
The error message that I get is.
ERROR:
subquery in FROM must have an alias
Hint: For example, FROM (SELECT ...) [AS] foo.
Position: 100
Trying to make sense of it..
Clive
-Original Message-
From: SQL Padawan [mailto:sql_pada...@protonmail.com]
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?
I would appreciate any pointers.
-- COUNT NEW SUPPLIER
--
SELECT new_sup,
COUNT(new_sup)
FRO
