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