>SELECT Resident.iid AS 'iresId',;
> Repondant.iid AS 'irepid';
> FROM amline!Resident ;
>    LEFT OUTER JOIN amline!Repondant ;
>   ON  Resident.iid = Repondant.iresidentid;
>   AND Repondant.lcopyfact ;
> ORDER BY Resident.iid
>
>