Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: summing totals in a query

    Well I think this might be just what you are looking for

    SELECT ABS(SUM(C)) as Sum, ID FROM

    (

    SELECT COUNT(*) AS C, 'A' AS ID FROM A

    UNION

    SELECT COUNT(*) AS C, 'B'...

Viewing post 1 (of 1 total)