SELECT SUM(*) as FINALVALUE
FROM
(
select count(*) as Count_A from A
UNION ALL
select count(*) as Count_B from B
UNION ALL
select count(*) as Count_C from C
UNION ALL
select count(*) as Count_D from D
UNION ALL
select -1*count(*) as Count_E from E
) T
* Noel