1 2 3 4 5 6 7 8 9 10 11
| Select DB.NumeroCot, Sum(CD.DT) Debit, Sum(DB.CT) Credit
FROM
(SELECT Numerocot, Periode, SUM(Credit) CT
FROM Linc.Secu_Ecr Where Journee = '20160223' And Canal = '12'
GROUP BY NumeroCot, Periode) DB,
(SELECT Numerocot, Periode, Sum(Debit) DT
FROM Linc.Secu_Ecr Where (SubStr(Libelle, 7, 4) = SubStr(Periode, 5, 2)||SubStr(Periode, 3, 2) OR
SubStr(Libelle, 7, 6) = SubStr(Periode, 5, 2)||SubStr(Periode, 1, 4) OR Libelle Like 'COM%')
GROUP BY NumeroCot, Periode) CD
Where DB.NumeroCot = CD.NumeroCot And DB.Periode = CD.Periode --And CD.Nature = CD.Nature
GROUP BY DB.NumeroCot |
Partager