1 2 3 4 5 6 7 8 9 10
|
SELECT T.*, P.STOCKAGE_PHOTO
FROM PERSONNES P INNER JOIN
(SELECT MAX(CS.DATE_ATTRIBUTION) AS Expr1, SP.NUMSERIE, PS.NOM, PS.PRENOM, PS.Dte_Naissance, PR.ID_PORTEUR, PR.ID_CARTE, PS.PHOTO, PR.ID_PERSONNE , CS.STATUT, CS.DATE_ATTRIBUTION, CS.DATE_OPPOSITION, CS.DATE_DELIVRANCE
FROM PORTEUR PR INNER JOIN PERSONNES PS ON PR.ID_PERSONNE = PS.ID_PERSONNE INNER JOIN
SUPPORTE SP ON PR.ID_CARTE = SP.ID_CARTE INNER JOIN
CARTES CS ON PR.ID_CARTE = CS.ID_CARTE AND SP.ID_CARTE = CS.ID_CARTE
WHERE PS.NOM = 'MOREAU' AND PS.PRENOM='Paule' AND STATUT in ('ACTIF','RESERVE')
GROUP BY PR.ID_PERSONNE, SP.NUMSERIE, PS.NOM, PS.PRENOM, PS.Dte_Naissance, PR.ID_PORTEUR, PR.ID_CARTE, PS.PHOTO, CS.STATUT, CS.DATE_ATTRIBUTION, CS.DATE_OPPOSITION, CS.DATE_DELIVRANCE) T ON
P.ID_PERSONNE = T.ID_PERSONNE |
Partager