it was very good but it a new question...



bernhart


>>BonJour fabio,
>>
>>I remember also:)
>>
>>if H.cpauseid # 0 AND H.cpauseid2 # 0 ........?
>>
>>
>>bernhart
>>
>
>Then, the last solve the issue ?
>
>>>Union is not necessary.
>>>
>>>If I remember good:
>>>

>>> 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
>>>