1 2 3 4 5 6 7 8 9 10
| SELECT t.NumeroCot || Cle(t.NumeroCot) Num_Emp, t.Periode--, t.nature
,Sum(t.Debit) Debit, Sum(t.Credit) Credit
FROM Linc.Secu_Ecr t,
(SELECT Numerocot, Periode, Nature, Canal, Ecriture, Journee
FROM Linc.Secu_Ecr WHERE Journee = '20160223' AND Canal = '12' ) b
WHERE t.NumeroCot = b.NumeroCot
AND t.Periode = b.Periode AND Substr(t.journee,1,4) = Substr(b.journee,1,4)
AND t.Nature = b.Nature AND t.Ecriture <> 'TC' AND t.Ecriture <> 'MC'
Group By t.NumeroCot, t.periode--, t.nature
Order by t.NumeroCot |
Partager