--- Raimon Fernandez <coder(at)montx(dot)com> wrote:
> but If I send the code that you send me, it takes too much .... well,
> more than 20 minutes and still waiting ...
just for testing try this version again so see if it preforms much better, then see if the summing
results are correct according to what you need.
SELECT A1.oid, A1.concepte, A1.deure, A1.haver,
sum( COALESCE( A1.deure, 0 ) - COALESCE( A2.haver, 0 )) AS value_sum
FROM Assentaments AS A1
INNER JOIN Assentaments AS A2
ON A1.oid <= A2.oid
WHERE A1.numero=11189
GROUP BY A1.oid, A1.concepte, A1.deure, A1.haver
ORDER BY A1.oid;