Thank borislav

SELECT COUNT( RECNO() ) , 'Résidants Présents dont :' FROM (AMLINE!Resident AS 'R';
LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE ;
ISNULL( e.iid )= .F. AND e.ltransfert= .F. AND e.dfin <> {} AND TTOD( r.dsortie ) = {} AND;
e.iid IN ( SELECT MAX( B.iid ) FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = e.iresidentid ) INTO CURSOR TEMP1



>Remove ORDER BY in Your SubQuery:
>
>

>SET ENGINEBEHAVIOR 80
>SELECT COUNT( RECNO() ),;
>       e.iid FROM (AMLINE!Resident AS 'R';
> LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid );
> WHERE e.iid IN ( SELECT B.iid FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = E.iresidentId GROUP BY B.iid)
>

>
>
>>Hi all,
>>
>>I have a error 1300 in my sql command.
>>Function name is missing
>>
>>
>>I do'nt see what happend..
>>5VFP 8.1 SET BEHA 80
>>

>>
>>SET ENGINEBEHAVIOR 80
>> SELECT COUNT( RECNO() )  , e.iid FROM (AMLINE!Resident AS 'R';
>>    LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE ;
>>    e.iid IN ( SELECT B.iid FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = E.iresidentId GROUP BY B.iid ORDER BY B.iid )
>>

>>
>>
>>Thank in advance for help
>>
>>bernhart