Re: UNION?

On Mon, 20 Jan 2003 08:52:09 -0500, Forest Felling
<res08i7v(at)verizon(dot)net> wrote:
>mydb=# select count(city) as qty, code as code
> from test_year
> where length(code) = 1
> group by code
> order by code
> union all
> select count(city) as qty, 'All' as code
> from test_year
> where length(code) = 1
>ERROR: parser: parse error at or near "all"
>Drop ALL, and get
>ERROR: parser: parse error at or near "select"

Try
SELECT * FROM (
SELECT ...
FROM test_year ...
GROUP BY ...
ORDER BY ... ) AS t1
UNION ALL
SELECT count(...), 'All' ...

or
SELECT 1, count(city) as qty, code as code
FROM ...
GROUP BY
UNION ALL
SELECT 2, count(city) as qty, 'All' as code
FROM ...
ORDER BY 1, 3;

Servus
Manfred