la suma de una suma

[flaviovich]

Bueno, seria mas o menos asi:

Código sql:

SELECT cant - SUM(campo), SUM(tabla3.suma)
FROM tabla1
INNER JOIN (
    SELECT pk, cant - SUM(campo) AS suma
    FROM tabla1
    GROUP BY pk, cant
) tabla3 ON tabla1.pk = tabla3.pk
GROUP BY cant