1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT F1.CWDCOMPT, SUM(F1.CWDMT) Crédit, SUM(F2.CWDMT) Débit
FROM FCWD F1 JOIN FCWD F2
ON F1.CWDCOMPT = F2.CWDCOMPT
WHERE F1.CWDDC = 'C'
AND F2.CWDDC = 'D'
GROUP BY F1.CWDCMPT
UNION
SELECT F1.CWDCOMPT, SUM(F1.CWDMT) Crédit, SUM(F2.CWDMT) Débit
FROM FCWD F1 EXCEPTION JOIN FCWD F2
ON F1.CWDCOMPT = F2.CWDCOMPT
WHERE F1.CWDDC = 'C'
AND F2.CWDDC = 'D'
GROUP BY F1.CWDCMPT
UNION
SELECT F1.CWDCOMPT, SUM(F1.CWDMT) Crédit, SUM(F2.CWDMT) Débit
FROM FCWD F1 EXCEPTION JOIN FCWD F2
ON F1.CWDCOMPT = F2.CWDCOMPT
WHERE F1.CWDDC = 'D'
AND F2.CWDDC = 'C'
GROUP BY F1.CWDCMPT
ORDER BY F1.CWDCMPT |
Partager