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] Sent: 23 September 2021 14:50 To: clives...@gmail.com Cc: pgsql-general@lists.postgresql.org Subject: RE: Get COUNT results from two different columns Hi, > I have two separate queries that work individually, returning a count from > each column. > I would appreciate any pointers. > new_sup, COUNT(new_sup) AS new_sup_count > old_sup, COUNT(old_sup) AS old_sup_count At least some of your problem is here - in your UNION-ed table, this is one and the same field and therefore cannot have two different names. HTH, SQL Padawan
