1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
SELECT
EMPLOYE.NUMEMP AS NUMEMP,
PPREVIS.DATE AS DATE,
PPREVIS.HEUREDP AS HEUREDP,
PPREVIS.HEUREFP AS HEUREFP,
PPREVIS.NUMTYPEH AS NUMTYPEH,
EMPLOYE.NOMEMP AS NOMEMP,
EMPLOYE.PREEMP AS PREEMP,
'PP' AS TYPE
FROM
EMPLOYE
INNER JOIN PPREVIS ON EMPLOYE.NUMEMP = PPREVIS.NUMEMP
WHERE
PPREVIS.DATE > (SELECT MAX(DATE) FROM PREALISE WHERE NUMEMP = ????)
AND PPREVIS.NUMTYPEH IN ('31', '32')
UNION ALL
SELECT
EMPLOYE.NUMEMP AS NUMEMP,
PREALISE.DATE AS DATE,
PREALISE.HEUREDR AS HEUREDR,
PREALISE.HEUREFR AS HEUREFR,
PREALISE.NUMTYPEH AS NUMTYPEH,
EMPLOYE.NOMEMP AS NOMEMP,
EMPLOYE.PREEMP AS PREEMP,
'PR' AS TYPE
FROM
PREALISE
INNER JOIN EMPLOYE ON EMPLOYE.NUMEMP = PREALISE.NUMEMP
WHERE
PREALISE.DATE>= '20130101'
AND PREALISE.NUMTYPEH IN ('31', '32')
ORDER BY
NUMEMP,
DATE,
TYPE |
Partager