1 2 3 4
|
SELECT
Cint(DCount("ANAT_TABPREALABLE_SPECIALITE.SPECIALITE_ID","ANAT_TABPREALABLE_SPECIALITE","ANAT_TABPREALABLE_SPECIALITE.SPECIALITE_ID <=" & ANAT_TABPREALABLE_SPECIALITE.SPECIALITE_ID)) AS ROWNUM, 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, ANAT_TABNUMERO_DOSSIER.ND_N_SEXE, ANAT_TABNUMERO_DOSSIER.ND_D_DATE_NAISS, ANAT_TABNUMERO_DOSSIER.ND_T_IPUM, ANAT_TABPREALABLE_SPECIALITE.N_AGE, ANAT_TABPREALABLE_SPECIALITE.D_DATE_EXAMEN, ANAT_TABPREALABLE_SPECIALITE.T_NUM_EXAMEN, ANAT_T_HOSPITALISE.T_LIBELLE AS T_TYPE_HOSPI, 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_T_GOUTTES.T_LIBELLE AS T_GOUTTE, 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_TABSPECIALITE_VENUE LEFT JOIN ANAT_TABPREALABLE_SPECIALITE ON ANAT_TABSPECIALITE_VENUE.SPECIALITE_ID = ANAT_TABPREALABLE_SPECIALITE.SPECIALITE_ID) ON ANAT_TABNUMERO_DOSSIER.ND_N_IDPATIENT = ANAT_TABSPECIALITE_VENUE.SV_N_IDPATIENT) LEFT JOIN ANAT_T_HOSPITALISE ON ANAT_TABPREALABLE_SPECIALITE.T_TYPE_HOSPI = ANAT_T_HOSPITALISE.T_CODE) LEFT JOIN ANAT_T_GOUTTES ON ANAT_TABPREALABLE_SPECIALITE.T_GOUTTES = ANAT_T_GOUTTES.T_CODE; |
Partager