From: Dani Castaños <danitao.mailists@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Having the sum of two queries
Date: Mon, 16 Jul 2007 13:06:21 +0200
Message-ID: <469B512D.70507@gmail.com> (raw)
Hi all!
I want to do something like this:
SELECT status, COUNT( status ) AS total
FROM users
GROUP BY status
UNION
SELECT status, COUNT(status) AS total
FROM imported_users
GROUP BY status
And have the result of both added.
I've tried something like
SELECT tot.status, COUNT(total)
FROM( QUERY A UNION QUERY B ) AS tot
GROUP BY tot.status
But it doesn't works. It doesn't add the total columns with the same
status...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: danitao.mailists@gmail.com
Subject: Re: Having the sum of two queries
In-Reply-To: <469B512D.70507@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox