1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SELECT ASS.nom_assure,
ASS.pre_assure,
CAN.profil_candidat,
EMP.description_emploi,
ASS.no_assure,
CAN.experience_candidat,
ASS.genre,
MAX (EMP.fin_emploi) as fin_emploi
FROM ASSURE ASS LEFT OUTER JOIN CANDIDAT CAN
ON ASS.no_assure = CAN.no_assure_fk,
CANDIDAT CAN LEFT OUTER JOIN EMPLOI EMP
ON CAN.no_assure_fk = EMP.no_assure_fk
WHERE ASS.is_candidat = 1
GROUP BY EMP.description_emploi,
ASS.nom_assure,
ASS.pre_assure,
CAN.profil_candidat,
ASS.no_assure,
CAN.experience_candidat,
ASS.genre; |
Partager