1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| UPDATE ma_table o
SET (o.col1, o.col2, o.col3, o.col4) =
(
select
sum(case tm.type when 'COND1' then montant else 0 end) as mnt_1,
sum(case tm.type when 'COND2' then montant else 0 end) as mnt_2,
sum(case tm.type when 'COND3' then montant else 0 end) as mnt_3,
sum(case tm.type when 'COND4' then montant else 0 end) as mnt_4
from
table_inter tm
where
tm.num = o.num
and tm.type IN ('COND1', 'COND2', 'COND3', 'COND4')
)
WHERE EXISTS (select null
from table_inter tm
where tm.num = o.num
and tm.type IN ('COND1', 'COND2', 'COND3', 'COND4')); |
Partager