Re: Joins with aggregate data

Thank you Michael, your suggestion works a charm (though I didn't
bother coalescing the two grp because I think the USING takes care of
that anyway.

Paul

On 7/8/05, Michael Fuhr <mike@fuhr.org> wrote:

> SELECT coalesce(g.grp, b.grp) AS grp,
>        coalesce(g.count, 0) AS countgood,
>        coalesce(g.sum, 0) AS sumgood,
>        coalesce(b.count, 0) AS countbad,
>        coalesce(b.sum, 0) AS sumbad
> FROM
>  (SELECT grp, count(good), sum(good) FROM lefty GROUP BY grp) AS g
> FULL OUTER JOIN
>  (SELECT grp, count(bad), sum(bad) FROM righty GROUP BY grp) AS b USING (grp);