1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
SELECT a.ncli, a.nart, a.per, b.per, a.do01, b.do01
FROM (
SELECT ncli, nart, substr(a4m2, 1, 4) AS per, sum(do01) do01
FROM st4std
WHERE a4m2 >= 200801
AND a4m2 <= 200912
AND ncli ='00053729'
GROUP BY ncli, nart, substr(a4m2, 1, 4)) a
LEFT OUTER JOIN
(
SELECT ncli, nart, substr(a4m2, 1, 4) AS per, sum(do01) do01
FROM st4std
WHERE a4m2 >= 200801
AND a4m2 <= 200912
AND ncli ='00053729'
GROUP BY ncli, nart, substr(a4m2, 1, 4)) b
ON a.ncli = b.ncli AND a.nart = b.nat AND a.per = b.per - 1 |
