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,
> >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 ) >>