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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
SELECT
ANAT_TABNUMERO_DOSSIER.ND_N_IDPATIENT,
ANAT_TABNUMERO_DOSSIER.ND_T_NUM_DOSSIER,
ANAT_TABNUMERO_DOSSIER.ND_T_NOM,
ANAT_TABNUMERO_DOSSIER.ND_T_PRENOM,
IIf(ANAT_TABNUMERO_DOSSIER.ND_N_SEXE='1','Masculin',IIf(ANAT_TABNUMERO_DOSSIER.ND_N_SEXE='2','Féminin','Non déterminé')) AS ND_N_SEXE,
ANAT_TABNUMERO_DOSSIER.ND_D_DATE_NAISS,
ANAT_TABNUMERO_DOSSIER.ND_T_IPUM,
ANAT_TABNUMERO_SIGMA.S_N_IDVENUE,
ANAT_TABNUMERO_SIGMA.S_T_SIGMA,
ANAT_TABPREALABLE_SPECIALITE.SPECIALITE_ID,
ANAT_TABPREALABLE_SPECIALITE.N_AGE,
ANAT_TABPREALABLE_SPECIALITE.D_DATE_EXAMEN,
ANAT_TABPREALABLE_SPECIALITE.T_NUM_EXAMEN,
ANAT_TABPREALABLE_SPECIALITE.T_DEMANDEUR,
ANAT_TABPREALABLE_SPECIALITE.T_NOM_DEMANDEUR,
ANAT_TABPREALABLE_SPECIALITE.T_ADR1,
ANAT_TABPREALABLE_SPECIALITE.T_ADR2,
ANAT_TABPREALABLE_SPECIALITE.T_CP,
ANAT_TABPREALABLE_SPECIALITE.T_VILLE,
ANAT_TABPREALABLE_SPECIALITE.T_EXAMEN_DIRECT,
ANAT_TABPREALABLE_SPECIALITE.T_RENS,
ANAT_TABPREALABLE_SPECIALITE.T_DENS_OD,
ANAT_TABPREALABLE_SPECIALITE.T_DENS_OG,
ANAT_TABPREALABLE_SPECIALITE.T_PHOTO_OD,
ANAT_TABPREALABLE_SPECIALITE.T_PHOTO_OG,
ANAT_TABPREALABLE_SPECIALITE.T_GOUTTES,
ANAT_TABPREALABLE_SPECIALITE.T_NOM_PHOTO_OD,
ANAT_TABPREALABLE_SPECIALITE.T_NOM_PHOTO_OG,
ANAT_TABPREALABLE_SPECIALITE.T_EXAMEN,
ANAT_TABPREALABLE_SPECIALITE.T_CONCLU,
ANAT_TABPREALABLE_SPECIALITE.T_COTATION,
ANAT_TABPREALABLE_SPECIALITE.T_PRN_DEMANDEUR,
ANAT_TABPREALABLE_SPECIALITE.T_EXAM_ANTERIEUR,
ANAT_TABPREALABLE_SPECIALITE.T_DS_OD,
ANAT_TABPREALABLE_SPECIALITE.T_DS_OG,
ANAT_TABPREALABLE_SPECIALITE.T_SURF_CM_OD,
ANAT_TABPREALABLE_SPECIALITE.T_SURF_CM_OG,
ANAT_TABPREALABLE_SPECIALITE.T_CV_OD,
ANAT_TABPREALABLE_SPECIALITE.T_CV_OG,
ANAT_TABPREALABLE_SPECIALITE.T_POLIT
FROM ((ANAT_TABNUMERO_DOSSIER LEFT JOIN ANAT_TABNUMERO_SIGMA ON ANAT_TABNUMERO_DOSSIER.ND_N_IDPATIENT = ANAT_TABNUMERO_SIGMA.S_N_IDPATIENT)
LEFT JOIN (ANAT_TABSPECIALITE_VENUE LEFT JOIN ANAT_TABPREALABLE_SPECIALITE
ON ANAT_TABSPECIALITE_VENUE.SPECIALITE_ID = ANAT_TABPREALABLE_SPECIALITE.SPECIALITE_ID)
ON ANAT_TABNUMERO_SIGMA.S_N_IDVENUE = ANAT_TABSPECIALITE_VENUE.SV_N_IDVENUE)
LEFT JOIN ANAT_T_HOSPITALISE ON ANAT_TABPREALABLE_SPECIALITE.T_TYPE_HOSPI = ANAT_T_HOSPITALISE.T_CODE
ORDER BY ANAT_TABNUMERO_DOSSIER.ND_N_IDPATIENT; |
Partager