Re: UNION?

On Mon, 20 Jan 2003 08:52:09 -0500, Forest Felling
<res08i7v@verizon.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