At 17:42 -0500 3/7/02, mike.miller@stripped wrote:
>Perhaps I misunderstand how the UNION statement is to be used, but the
>following query doesn't work as I'd expect:
>
>SELECT column_id, SUM(column_a) AS positive_a FROM table_a WHERE column_b =
>'positive'
>UNION
>SELECT column_id, SUM(column_a) AS negative_a FROM table_a WHERE columb_b =
>'negative'
>
>I would expect to receive three columns back (column_id, positive_a,
Why do you expect three?
>negative_a), but what I receive is two columns, with the duplicate
>column_id's and the negative_a results being lumped under the positive_a
>column.
Sounds like maybe you want some kind of join rather than a UNION?
>
>Can anyone point me in the right direction on this? This is MysQL 4.0.1
>FreeBSD binary install.
>
>--
>Mike Miller, BMG Canada Inc.
>Tel: 416-586-1646
>Fax: 416-586-1661
>EMail: mike.miller@stripped
