1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT NoEmploye, CodeEmploye, NomEmploye, PNomEmploye
FROM EMPLOYE
WHERE NoEmploye IN (SELECT NoEmploye FROM GARDE G, GARDER GR
WHERE GR.NoGarde=G.NoItem
AND NoItem NOT IN(SELECT NoItem
FROM GARDE
WHERE DTBegin<=:p1
AND DTEnd>=:p2)
AND NoItem NOT IN(SELECT NoItem
FROM GARDE
WHERE DTBegin>=:p1
AND DTEnd<=:p2)
AND NoItem NOT IN(SELECT NoItem
FROM GARDE
WHERE DTBegin<=:p1
AND DTEnd<=:p2)
AND NoItem NOT IN(SELECT NoItem
FROM GARDE
WHERE DTBegin>=:p1
AND DTEnd>=:p2)
); |
Partager