1 2 3
|
SELECT DISTINCT EFFORT_TABNUMERO_DOSSIER.ND_N_IDPATIENT, EFFORT_TABNUMERO_DOSSIER.ND_T_NUM_DOSSIER, EFFORT_TABNUMERO_DOSSIER.ND_T_NOM, EFFORT_TABNUMERO_DOSSIER.ND_T_PRENOM, T_SEXE.SEX_LIB AS ND_N_SEXE, EFFORT_TABNUMERO_DOSSIER.ND_D_DATE_NAISS, EFFORT_TABNUMERO_DOSSIER.ND_T_IPUM, EFFORT_TABEFFORT_VENUE.EFFORT_ID, EFFORT_TABEFFORT_VENUE.E_N_IDVENUE, EFFORT_TABEFFORT_VENUE.E_D_DATE_EPREUVE, EFFORT_TABEFFORT_VENUE.E_N_NUM_EPREUVE, EFFORT_TABPREALABLE_EFFORT.PE_N_HEURE, EFFORT_TABMEDECINS.T_LIBELLE AS PE_N_DEMANDEUR, EFFORT_TABHOSPITALISATION.T_LIBELLE AS PE_N_HOSPI, EFFORT_TABPRATICIENS_HOSPI.T_LIBELLE AS PE_N_PRAT_HOSPITALIER, EFFORT_TABPRATICIENS_ATTAC.T_LIBELLE AS PE_N_PRAT_ATTACHE, EFFORT_TABPREALABLE_EFFORT.PE_M_HIST_MALADIE, EFFORT_TABPREALABLE_EFFORT.PE_M_TRAITEMENT_JOUR, indications(EFFORT_TABPREALABLE_EFFORT.EFFORT_ID) AS IE_N_INDICATIONS, EFFORT_TABINDICATION_EFFORT.IE_T_AUTRES_INDICATIONS, EFFORT_TABPREALABLE_EFFORT.PE_N_AGE, EFFORT_TABPREALABLE_EFFORT.PE_N_POIDS, EFFORT_TABPREALABLE_EFFORT.PE_N_TAILLE, EFFORT_TABINFIRMIERES.T_LIBELLE AS PE_N_INFIRMIERE, EFFORT_TABTYPE_PROTOC.T_LIBELLE AS PE_N_PROTOCOLE, EFFORT_TABEFFORT_SALLES.T_LIBELLE AS PE_N_SALLE, EFFORT_TABPREALABLE_EFFORT.PE_B_TNT, EFFORT_TABPREALABLE_EFFORT.PE_B_THALLIUM, EFFORT_TABPREALABLE_EFFORT.PE_B_VO2, EFFORT_TABPREALABLE_EFFORT.PE_N_FREQ_REPOS, EFFORT_TABPREALABLE_EFFORT.PE_N_TAS_REPOS, EFFORT_TABPREALABLE_EFFORT.PE_N_TAD_REPOS, EFFORT_TABPREALABLE_EFFORT.PE_M_COMMENT_REPOS, EFFORT_TABEPREUVES_ABRUP.T_MINUTE_PALIER AS PE_N_EPREUVES, EFFORT_TABPREALABLE_EFFORT.PE_N_PALIER_DEBUT
FROM ((((((((((((EFFORT_TABNUMERO_DOSSIER LEFT JOIN EFFORT_TABEFFORT_VENUE ON EFFORT_TABNUMERO_DOSSIER.ND_N_IDPATIENT = EFFORT_TABEFFORT_VENUE.E_N_IDPATIENT) LEFT JOIN T_SEXE ON EFFORT_TABNUMERO_DOSSIER.ND_N_SEXE = T_SEXE.SEX_NUM) LEFT JOIN EFFORT_TABPREALABLE_EFFORT ON EFFORT_TABEFFORT_VENUE.EFFORT_ID = EFFORT_TABPREALABLE_EFFORT.EFFORT_ID) LEFT JOIN EFFORT_TABMEDECINS ON EFFORT_TABPREALABLE_EFFORT.PE_N_DEMANDEUR = EFFORT_TABMEDECINS.N_CODE) LEFT JOIN EFFORT_TABHOSPITALISATION ON EFFORT_TABPREALABLE_EFFORT.PE_N_HOSPI = EFFORT_TABHOSPITALISATION.N_CODE) LEFT JOIN EFFORT_TABPRATICIENS_HOSPI ON EFFORT_TABPREALABLE_EFFORT.PE_N_PRAT_HOSPITALIER = EFFORT_TABPRATICIENS_HOSPI.N_CODE) LEFT JOIN EFFORT_TABPRATICIENS_ATTAC ON EFFORT_TABPREALABLE_EFFORT.PE_N_PRAT_ATTACHE = EFFORT_TABPRATICIENS_ATTAC.N_CODE) LEFT JOIN EFFORT_TABEFFORT_SALLES ON EFFORT_TABPREALABLE_EFFORT.PE_N_SALLE = EFFORT_TABEFFORT_SALLES.N_CODE) LEFT JOIN EFFORT_TABINFIRMIERES ON EFFORT_TABPREALABLE_EFFORT.PE_N_INFIRMIERE = EFFORT_TABINFIRMIERES.N_CODE) LEFT JOIN EFFORT_TABTYPE_PROTOC ON EFFORT_TABPREALABLE_EFFORT.PE_N_PROTOCOLE = EFFORT_TABTYPE_PROTOC.N_CODE) LEFT JOIN EFFORT_TABEPREUVES_ABRUP ON EFFORT_TABPREALABLE_EFFORT.PE_N_EPREUVES_ABRUTE = EFFORT_TABEPREUVES_ABRUP.N_CODE) LEFT JOIN EFFORT_TABINDICATION_EFFORT ON EFFORT_TABEFFORT_VENUE.EFFORT_ID = EFFORT_TABINDICATION_EFFORT.EFFORT_ID) LEFT JOIN EFFORT_TABINDICATIONS_LIBELLE ON EFFORT_TABINDICATION_EFFORT.IE_N_INDICATIONS = EFFORT_TABINDICATIONS_LIBELLE.N_CODE; |