1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT S6PBPOS.DATJOUR, S6PBPOS.CODELIEU, max(S6PBPOS.EFFMINI) as besoin,SUM(HOPHJOU.IJQHSMAEXO/60/12) as EFFJOUR
FROM S6PBPOS, HOPHJOU, HOPEMPL,HOPHABS,S6PPLGT
WHERE SUBSTR( S6PBPOS.CODELIEU,0,3)='SPO'
AND HOPHJOU.DAT = S6PBPOS.DATJOUR
AND HOPHJOU.MATRI = HOPEMPL.MATRI
AND HOPEMPL.MATRI = HOPHABS.MATRI
AND S6PBPOS.DATJOUR = HOPHABS.DAT
AND HOPHABS.MOTIF = S6PPLGT.ACTGT
AND S6PBPOS.CODELIEU = S6PPLGT.CODELIEU
AND EXTRACT(YEAR FROM S6PBPOS.DATJOUR)= 2015 AND EXTRACT( MONTH FROM S6PBPOS.DATJOUR) = 1
AND S6PBPOS.CODELIEU in ('SPOEOGVJCA')
AND HOPHJOU.JOUR in ( 6,7)
GROUP BY S6PBPOS.DATJOUR, S6PBPOS.CODELIEU |
Partager