At 17:42 -0500 3/7/02, [EMAIL PROTECTED] 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
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
