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'...