1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| with EM_employe(EM_ident, EM_nom) as
(select 1, 'dupont' union all
select 2, 'martin' union all
select 3, 'zorglub'
)
, CA_calendrier(CA_date) as
(select '2020-01-03' union all
select '2020-01-06' union all
select '2020-01-07' union all
select '2020-01-09'
)
, TA_tache(TA_ident, TA_date, EM_ident) as
(select 1, '2020-01-03', 1 union all
select 2, '2020-01-03', 3 union all
select 3, '2020-01-07', 1 union all
select 4, '2020-01-09', 2 union all
select 5, '2020-01-09', 2
) |
Partager