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
|
SELECT MOD_DMO.operateur, SUM(Tpsmo) AS temps1
FROM MOD_DMO
GROUP BY operateur
SELECT MOD_AccomRecou.operateur, SUM(Tpsmo) AS temps2
FROM MOD_AccomRecou
GROUP BY operateur
SELECT MOD_Travail.operateur, SUM(TempsMo) AS temps3
FROM MOD_Travail
GROUP BY operateur
SELECT temps1 + temps2 + coalesce(temps3,0)
FROM
(SELECT MOD_DMO.Dates, MOD_DMO.operateur, SUM(Tpsmo) AS temps1
FROM MOD_DMO
GROUP BY operateur,Dates
)req1 join
(SELECT MOD_AccomRecou.Dates,MOD_AccomRecou.operateur, SUM(Tpsmo) AS temps2
FROM MOD_AccomRecou
GROUP BY operateur,Dates
)req2 on req1.Operateur=req2.Operateur and req1.Dates = req2.Dates
left join
(SELECT MOD_Travail.Dates, MOD_Travail.operateur, SUM(TempsMo) AS temps3
FROM MOD_Travail
GROUP BY operateur,Dates
)req3 on req1.operateur=req3.operateur and req1.Operateur=req2.Operateur and req1.Dates = req3.Dates
where req1.operateur='60216004'
and req1.Dates='16/12/2016' |
Partager