1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT
DTW_COM_CENT_1.Code_Niv_1 AS Niv_1,
DTW_COM_CENT_1.Libelle_Niv_1 AS Libelle_1,
DTW_COM_CENT_2.Code_Niv_2 AS Niv_2,
DTW_COM_CENT_2.Libelle_Niv_2 AS Libelle_2,
DTW_COM_CENT_3.Code_Niv_3 AS Niv_3,
DTW_COM_CENT_3.Libelle_Niv_3 AS Libelle_3,
DTW_COM_CENT_4.Code_Niv_4 AS Niv_4,
DTW_COM_CENT_4.Libelle_Niv_4 AS Libelle_4
FROM
DTW_COM_CENT_4 FULL OUTER JOIN DTW_COM_CENT_3 ON DTW_COM_CENT_3.Code_Niv_4=DTW_COM_CENT_4.Code_Niv_4,
DTW_COM_CENT_3 FULL OUTER JOIN DTW_COM_CENT_2 ON DTW_COM_CENT_2.Code_Niv_3=DTW_COM_CENT_3.Code_Niv_3,
DTW_COM_CENT_2 FULL OUTER JOIN DTW_COM_CENT_1 ON DTW_COM_CENT_1.Code_Niv_2=DTW_COM_CENT_2.Code_Niv_2 |
Partager