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