1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| with Tab1(cpt) as
(select 001 union all
select 002 union all
select 003 union all
select 004 union all
select 005
)
, Tab2(cpt, sct, mnt) as
(select 001, 001, 500.00 union all
select 001, 010, 220.50 union all
select 001, 001, 300.00 union all
select 001, 002, 130.07 union all
select 001, 001, 100.00 union all
select 003, 010, 333.00 union all
select 003, 010, 444.00 union all
select 003, 020, 777.00 union all
select 003, 010, 111.00 union all
select 004, 002, 044.44 union all
select 004, 002, 011.22
) |
Partager