Created
July 16, 2019 05:33
-
-
Save achampav/d11a087ca3c11f2f34fbcb08a2d4a243 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
with agregat_metier as ( | |
select | |
a.d1,a.c1,a.c2,b.c3,b.c4,b.c5,c.c6,c.c7,sum(c.c8) c8 | |
from | |
t1 a | |
join t2 b on a.t2_id = b.id | |
join t3 c on b.t3_id = c.id | |
where | |
a.d1 between to_date(&dte_min,'YYYY-MM-DD') and to_date(&dte_max,'YYYY-MM-DD') | |
group by | |
a.d1,a.c1,a.c2,b.c3,b.c4,b.c5,c.c6,c.c7 | |
) | |
select | |
a.d1,d.ca,d.cb,d.cc,a.c1,a.c2,a.c3,a.c4,a.c5,a.c6,a.c7,a.c8 | |
from | |
t4 d | |
join agregat_metier a on d.t1_id = a.id | |
where | |
d.cd in ('R1','R2','AB3') | |
and d.ce = &filtre1 | |
union | |
select | |
a.d1,d.ca,d.cb,d.cc,a.c1,a.c2,a.c3,a.c4,a.c5,a.c6,a.c7,a.c8 | |
from | |
t4 d | |
join agregat_metier a on d.t1_id = a.id | |
where | |
d.cd in ('R2','ZZ4','ZZ8') | |
and d.ce = &filtre2 | |
union | |
select | |
a.d1,d.ca,d.cb,d.cc,a.c1,a.c2,a.c3,a.c4,a.c5,a.c6,a.c7,a.c8 | |
from | |
t4 d | |
join agregat_metier a on d.t1_id = a.id | |
where | |
d.cd in ('R1','ZZ8','AB3') | |
and d.ce = &filtre3; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment