Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSelect distinct C.DTE_ENTRE, P.MATRI_PERSONNE, P.NOM_PERS, P.PRENOM_PERS From CIS_PERSONNE_AFF C Join (Select MATRI_CIS_PERS, MAX(DTE_ENTRE) AS LastestDate from CIS_PERSONNE_AFF WHERE (DTE_ENTRE < (SELECT MAX(DTE_ENTRE) FROM CIS_PERSONNE_AFF)) Group By MATRI_CIS_PERS) as Latest On Latest.MATRI_CIS_PERSC.MATRI_CIS_PERS and Latest.LastestDate C.DTE_ENTRE Join PERSONNE P On P.MATRI_PERSONNE = C.MATRI_CIS_PERS WHERE CODE_STATUT='VOL'
SELECT * FROM maTable WHERE truc IS NULL;
Select distinct C.DTE_ENTRE, P.MATRI_PERSONNE, P.NOM_PERS, P.PRENOM_PERS From CIS_PERSONNE_AFF C Join (Select MATRI_CIS_PERS, MAX(DTE_ENTRE) AS LastestDate from CIS_PERSONNE_AFF WHERE (DTE_ENTRE < (SELECT MAX(DTE_ENTRE) FROM CIS_PERSONNE_AFF)) Group By MATRI_CIS_PERS) as Latest On Latest.MATRI_CIS_PERSC.MATRI_CIS_PERS and Latest.LastestDate C.DTE_ENTRE Join PERSONNE P On P.MATRI_PERSONNE = C.MATRI_CIS_PERS WHERE CODE_STATUT='VOL'
Select distinct C.DTE_ENTRE, P.MATRI_PERSONNE, P.NOM_PERS, P.PRENOM_PERS From CIS_PERSONNE_AFF C Join (Select MATRI_CIS_PERS, MAX(DTE_ENTRE) AS LastestDate from CIS_PERSONNE_AFF WHERE (DTE_ENTRE < (SELECT MAX(DTE_ENTRE) FROM CIS_PERSONNE_AFF)) Group By MATRI_CIS_PERS) Latest On Latest.MATRI_CIS_PERSC.MATRI_CIS_PERS and Latest.LastestDate C.DTE_ENTRE Join PERSONNE P On P.MATRI_PERSONNE = C.MATRI_CIS_PERS WHERE CODE_STATUT='VOL'