>sorry !
>
>Horaire.dbf
>iid I
>iemployeeid I
>cpauseid I
>cpauseid2 I
>nho1 N(5,2)
>nho2 N(5.2)
>
>employee.dbf
>iid
>etc...
>
>I want count ( Horaire.iemployeeid ) where (cpauseid and cpauseid2) # 0 OR cpauseid # 0 OR cpauseid2 # 0 ( condition = .T. )
>
>

select Employee.cName;
,     X.Total;
FROM FORCE (SELECT iemployeeid  ;
,     COUNT(*) Total;
       from horaire WHERE cpauseid#0 OR cpauseid2#0 GROUP BY 1) X ;
    join Employee on Employee.iid=X.iemployeeid;
    ORDER BY 1