1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| select datefact as d_date, mont, regl
from
(select datefact as d_date, sum(montfact) as mont
from factures
group by datefact) fact
left outer join
(select dateregl, sum(montfact) as regl
from factures f, reglements r
where f.numregl=r.numregl
group by dateregl) regl
on datefact=dateregl
union
select datregl as d_date, 0 as mont, regl
from
(select dateregl, sum(montfact) as regl
from factures f, reglements r
where f.numregl=r.numregl
group by dateregl) regl
where dateregl not in
(select distinct datefact from factures) |
Partager