>>> SELECT ; >>> H.iemployeeid ; >>> , COUNT(*) totaljo ; >>> , SUM( IIF( E.Lassimilinami AND P.Iassimilid , 0.00, H.n100 + H.n100_2 + H.n120 + H.n120_2 )) totHoNAs ; >>>, SUM( IIF( E.Lassimilinami AND P.Iassimilid , H.n100 + H.n100_2 + H.n120 + H.n120_2 , 0.00 )) totHoAs ; >>> FROM Horaire H ; >>> JOIN PAUSE P ON P.iid=EVL(H.cpauseid,H.cpauseid2) ; >>> JOIN Employee E ON E.iid = H.iemployeeid; >>> WHERE H.ddate BETWEEN m.D_debut AND m.d_fin >>> GROUP BY 1; >>> INTO CURSOR temp >>>