bonjour fabio,

result is not in horaire.dbf.
SUM(Result) Total ???

bernhart



>>Hi,
>>
>>
>>i have :
>>
>>Employee.dbf
>>horaire.dbf ( cpauseid AND cPauseId2 )
>>
>>I want
>>
>>SELECT Employee.cName , X.total => (sum of result(3))
>>

>>cpauseid     cpauseid2      Result
>>14             0              1
>>0              14             1
>>0              0              0
>>14             14             1
>>

>>
>>How can i do it please ( VFP 9 )
>>
>>
>>Thank in advance
>>
>>bernhart
>
>

>select Employee.cName;
>,     X.Total;
>FROM (SELECT EVL(cpauseid,cpauseid2) ID;
>,     SUM(Result) Total;
>       from horaire GROUP BY 1) X ;
>    join Employee on Employee.id=X.ID;
>    ORDER BY 1
>