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 29 30
| SELECT
ENS_ID_VOIE,
PAN_ANNEE_FAB,
EQM_CODE_PP,
EQM_TYPE_PP,
SADR_NOM,
SS_NOM,
ENS_SENS,
ENS_PR,
LATE_NOM,
GAM_NOM,
TSUP_TYPE
FROM
PP_LATERAL,
PP_SADRE_SUP,
PP_T_SUP,
PP_EQUIP,
PP_SADRE,
PP_GAMME,
PP_ENS,
PP_PANNO
WHERE
PP_ENS.ENS_ID=PP_PANNO.PAN_ID_ENS
AND PP_GAMME.GAM_ID=PP_PANNO.PAN_ID_GAMME
AND PP_SADRE.SADR_ID=PP_PANNO.PAN_SADRE
AND PP_EQUIP.EQM_ID=PP_PANNO.PAN_ID_CODE_PP
AND PP_T_SUP.TSUP_ID=PP_ENS.ENS_ID_TYPE_SUP
AND PP_ENS.ENS_ID_SADRE=PP_SADRE_SUP.SS_ID
AND PP_ENS.ENS_ID_LATERALISATION=PP_LATERAL.LATE_ID
ORDER BY ENS_ID_VOIE; |
Partager