1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| Select B.code, B.name, B.indicateurM, Z.indicateurM-1
from
(
(SELECT
tab1.code as code,
tab2.name as name ,
sum(tab1.indicateur) as indicateurM
FROM
tab1,tab2
WHERE
tab1.code1=tab2.code1
and (tab1.date=201102)
group by tab1.code,
tab2.name ) B
Union
(SELECT
tab1.code as code ,
tab2.name as name ,
sum(tab1.indicateur) as indicateurM-1
FROM
tab1,tab2
WHERE
tab1.code1=tab2.code1
and tab2.date=201104
GROUP BY tab1.code ,
tab2.name ) Z
)
where Z.code=B.code
AND Z.name=B.name
group by B.code,B.name; |
Partager