Il me smeble qu'il faille faire un alias de table dans ce cas présent:
SELECT MIN(D1.date_pointage), MAX(D2.date_pointage)
FROM pointage D1, pointage D2
WHERE
agent = numAgent
AND
observation = Congé
AND
NOT EXISTS (SELECT * from pointage where observation <> 'Congé' and date_pointage between d1 and d2);
[^] # Re: hmmm
Posté par Dabowl_94 . En réponse au message SQL update et select.. Évalué à 2.
SELECT MIN(D1.date_pointage), MAX(D2.date_pointage)
FROM pointage D1, pointage D2
WHERE
agent = numAgent
AND
observation = Congé
AND
NOT EXISTS (SELECT * from pointage where observation <> 'Congé' and date_pointage between d1 and d2);
bloub° bloub°
dabowl_75