• 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