Viewing post 1 (of 1 total)
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'...
March 3, 2004 at 8:41 am
#496951