1 2 3 4 5 6 7 8
| SELECT TABaff.NUMaff, TABaff.TYPetd, TABaff.INTaff, TABaff.RESaff, TABaff.LOCaff, TABstat.CODstat, Sum(TABetu.DEVetu) AS SommeDeDEVetu, Sum(TABetu.FACetu) AS SommeDeFACetu, RsomPaff.SommeDeHEURE, Sum(TABbud.HTTbud) AS SommeDeHTTbud, [SommeDeFACetu]-[SommeDeDEVetu] AS Edev_fac, [SommeDeHTTbud]-[SommeDeHEURE] AS EhPREV_hREEL, Sum([SommeDeHEURE]*[TABbud]![THTbud]) AS DepREEL, ([SommeDeHEURE]-[SommeDeHTTbud])/[SommeDeHTTbud] AS PecartPREVreelle, TABaff.DATsyn, TABaff.CAUaff, TABaff.DATarch, TABaff.BOITarch,
CASE PecartPREVreelle
WHEN >'0.2' THEN '2'
WHEN <'0.2' THEN '1'
ELSE '0'
END
FROM TABstat INNER JOIN ((((TABaff LEFT JOIN RsomPaff ON TABaff.NUMaff = RsomPaff.NUMaff) INNER JOIN TABcde ON TABaff.NUMaff = TABcde.AFFcde) LEFT JOIN TABbud ON TABcde.IDcde = TABbud.CDEbub) LEFT JOIN TABetu ON TABcde.IDcde = TABetu.CDEetu) ON TABstat.IDstat = TABaff.STATaff
GROUP BY TABaff.NUMaff, TABaff.TYPetd, TABaff.INTaff, TABaff.RESaff, TABaff.LOCaff, TABstat.CODstat, RsomPaff.SommeDeHEURE, TABaff.DATsyn, TABaff.CAUaff, TABaff.DATarch, TABaff.BOITarch; |
Partager