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