1 2 3
| SELECT PATIENT.NOM_PATIENT, PATIENT.PRENOM_PATIENT, CONSULTATION.DATE_CONSULTATION, CONSULTATION.ID_CONSULTATION, CONSULTATION.TYPE_CONSULTATION, [PARTICIPER ATELIER].PRESENCE_ATELIER, ATELIER.DATE_ATELIER, ATELIER.ID_ATELIER, ACTIVITE.TYPE_ACTIVITE
FROM (PATIENT INNER JOIN ((ACTIVITE INNER JOIN ATELIER ON ACTIVITE.ID_ACTIVITE = ATELIER.ACTIVITE_ATELIER) INNER JOIN [PARTICIPER ATELIER] ON ATELIER.ID_ATELIER = [PARTICIPER ATELIER].ID_ATELIER) ON PATIENT.ID_PATIENT = [PARTICIPER ATELIER].ID_PATIENT) INNER JOIN CONSULTATION ON PATIENT.ID_PATIENT = CONSULTATION.ID_PATIENT_CONSULTATION
WHERE ((([PARTICIPER ATELIER].PRESENCE_ATELIER)=True)); |
Partager