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 DISTINCT
FORMATIONS.FOR_Libelle AS FOR_Libelle,
FORMATIONS.FOR_DuréeValidité AS FOR_DuréeValidité,
AFFECTATIONS_FORMATIONS.DateAcquisition_FORM AS DateAcquisition_FORM,
PERSONNEL.PE_NomPrenom AS PE_NomPrenom,
PERSONNEL.SE_Code AS SE_Code,
PERSONNEL.PE_Site AS PE_Site,
PERSONNEL.PE_FFonction AS PE_FFonction,
SERVICES.SE_Libelle AS SE_Libelle,
FORMATIONS.IDFORMATIONS AS IDFORMATIONS,
FORMATIONS.FOR_Organisme AS FOR_Organisme,
FORMATIONS.FOR_Financement AS FOR_Financement,
FORMATIONS.FOR_IncidenceQUAL AS FOR_IncidenceQUAL
FROM
AFFECTATIONS_FORMATIONS,
FORMATIONS,
PERSONNEL,
SERVICES
WHERE
PERSONNEL.SE_Code = SERVICES.SE_Code
AND AFFECTATIONS_FORMATIONS.IDFORMATIONS = FORMATIONS.IDFORMATIONS
AND AFFECTATIONS_FORMATIONS.PE_Id = PERSONNEL.PE_Id
AND PERSONNEL.PE_Presence = 1
OR PERSONNEL.PE_Presence = 0
AND AFFECTATIONS_FORMATIONS.DateAcquisition_FORM BETWEEN 20120101 AND 20121231
ORDER BY
IDFORMATIONS ASC,
PE_NomPrenom ASC |