1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| with T1_CLI(T1_ident, T1_nom) as
(select 1, 'client machin' union all
select 2, 'Client Toto' union all
select 3, 'Société bidule' union all
select 4, 'Machin SARL' union all
select 5, 'Dugenou & Cie'
)
, T2_VTE(T1_ident, T2_date, T2_CA) as
(select 1, '2021-01-31', 0100.50 union all
select 1, '2021-02-28', 0080.37 union all
select 2, '2021-01-31', 1800.61 union all
select 2, '2021-03-31', 0467.24 union all
select 3, '2021-01-31', 0671.45 union all
select 3, '2021-02-28', 1030.02 union all
select 4, '2021-06-30', 1234.56
) |
Partager