1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
SELECT A.Nom AS `Nom de l''agent`, A.Prenom AS `Prénom de l''agent`,
A.MatriculeIncorporation AS `Mle incorp`,
A.MatriculeSolde AS `Mle solde`, C.LibelleCategorie AS `Categorie`,
G.LibelleGrade AS `Grade`, RA.DateRetraite AS `Date retraite`
FROM Agents AS A INNER JOIN
Promotion_Agents AS PA ON PA.ID = A.ID INNER JOIN
Grades AS G ON G.IDgrade = PA.IDgrade INNER JOIN
Categorie AS C ON C.IDcategorie = G.IDcat
WHERE A.ID IN
(SELECT *
FROM Retraite_Agents) AND RA.DateRetraite BETWEEN [A.`Date debut`] AND [A.`Date fin`] AND
(SELECT COUNT(*)
FROM Promotion_Agents AS PA2
WHERE PA2.ID = PA.ID AND
PA.DatePromotion < PA2.DatePromotion) < 1 |
Partager