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
| with TAB0(T0_user, T0_res, T0_tra, T0_loc) as
(select 01, '12345', '12345', '1' union all
select 02, '12345', '12345', '1' union all
select 03, '12345', '12345', '2' union all
select 04, '12345', '12345', '2' union all
select 05, '12345', '12345', '2' union all
select 06, '12345', '12345', '4' union all
select 07, '12345', '12345', '4' union all
select 08, '12345', '22222', '1' union all
select 09, '12345', '22222', '1' union all
select 10, '12345', '22222', '1' union all
select 11, '12345', '22222', '4' union all
select 12, '12345', '22222', '4' union all
select 13, '12345', '33333', '3' union all
select 14, '12345', '33333', '5' union all
select 15, '12345', '33333', '5'
)
, TAB1(T1_code, T1_lib) as
(select '12345', 'glumotte les arpions' union all
select '22222', 'champignac en cambrousse' union all
select '33333', 'chichigneux'
)
, TAB2(T2_tra, T2_loc, T2_nbr) as
(select T0_tra, T0_loc, count(*)
from TAB0
group by T0_tra, T0_loc
) |
Partager