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