Untitled

SELECT NOMBRE,SUM(ST) AS SUBTOTAL, SUM(D) AS DESCUENTO, SUM(T) AS TOTAL FROM (SELECT NOM_SBLINEA AS NOMBRE, TIPODCTO, SUM(SUBTOTAL) AS ST, SUM(DESCUENTO) AS D, SUM(TOTAL) AS T FROM ZVTAMQ06 WHERE PERIODO = '7' GROUP BY NOM_SBLINEA, TIPODCTO) GROUP BY NOMBRE