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 28
|
with tab (ID, CodeProcessus, LibelleProcessus, PereProcessus) as
(select 1, 'ARE', 'Libelle ARE', null union all
select 2, 'DSF', 'Libelle DSF', 'ARE' union all
select 3, 'VDFG', 'Libelle VDFG', null union all
select 4, 'CVD', 'Libelle CVD', 'VDFG' union all
select 5, 'CSX', 'Libelle CSX', 'ARE' union all
select 6, 'HJK', 'Libelle HJK', 'ARE'
)
select T1.ID
, T1.CodeProcessus
, T1.LibelleProcessus
, T2.CodeProcessus
, T2.LibelleProcessus
from tab as T1
inner join tab as T2
on T2.PereProcessus = T1.CodeProcessus
where T1.PereProcessus is null
union all
select T1.ID
, T1.CodeProcessus
, T1.LibelleProcessus
, ' '
, ' '
from tab as T1
where T1.PereProcessus is null
order by T1.CodeProcessus
, T2.CodeProcessus |
Partager