y porque no haces esto:
Código SQL:
Ver originalSELECT CASE WHEN clave=1 THEN debe - Haber END AS saldo_inicial,
CASE WHEN clave=2 THEN debe - haber END AS modificados,
CASE THEN clave=3 THEN debe-haber END AS definitivos
FROM Database1 AS D2 INNER JOIN
D2.id = D.id