Fórum Somar total das colunas com o select sum(lt;lt;campogt;g #58276

SELECT C.GRAUD AS GRAU, C.valor_A, C.valor_b, 
(C.valor_A - C.valor_b) AS SALDO 
FROM (SELECT A1.GRAUD, A1.valor_A, B1.GRAUC, B1.valor_b 
FROM (SELECT TGRAU1_D.GRAUD, sum(TGRAU1_D.valor) AS 
valor_A FROM TGRAU1_D GROUP BY TGRAU1_D.GRAUD) AS A1, 
(SELECT TGRAU1_C.GRAUC, SUM(TGRAU1_C.valor) AS valor_b 
FROM TGRAU1_C GROUP BY TGRAU1_C.GRAUC ) AS B1) AS C 
WHERE C.GRAUD=C.GRAUC 

union

SELECT C.GRAU2D AS GRAU, C.valor_A, C.valor_b, 
(C.valor_A - C.valor_b) AS SALDO 
FROM (SELECT A1.GRAU2D, A1.valor_A, B1.GRAU2C, B1.valor_b 
FROM (SELECT TGRAU2_D.GRAU2D, sum(TGRAU2_D.valor) AS 
valor_A FROM TGRAU2_D GROUP BY TGRAU2_D.GRAU2D) AS A1, 
(SELECT TGRAU2_C.GRAU2C, SUM(TGRAU2_C.valor) AS valor_b 
FROM TGRAU2_C GROUP BY TGRAU2_C.GRAU2C ) AS B1) AS C 
WHERE C.GRAU2D=C.GRAU2C