Hi,

It looks like you might have an join problem to me:

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

you have this as a left outer join-- meaning that we can have as result with non null resident.iid but repondant.id is NULL. This means that repondant.lcopyfact is also null. Meaning that your left join is really identical to a simple inner join!

Now I don't know if that is specifically your problem but it is a problem with the query.

Hope that helps,
Jamie



>HI ALL,
>
>I have
>
>resident.dbf
>IID I
>
>repondant.dbf
>iid I
>iresidentid I
>lcopy L
>
>
>I want ALL residents AND all repondants if lcopy = .T.
>
>This code do'nt function...
>
>

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

>
>thank in advance
>
>bernhart