>CREATE CURSOR RESIDENT ( iid I ) > > CREATE CURSOR REPONDANT ( iid I , IRESIDENTID I , Lcopy L ) > > FOR x = 1 TO 10 > INSERT INTO RESIDENT ( iid ) VALUES ( x ) > ENDFOR > > INSERT INTO REPONDANT ( iid , IRESIDENTID , Lcopy ) VALUES ( 1, 2 , .F.) > INSERT INTO REPONDANT ( iid , IRESIDENTID , Lcopy ) VALUES ( 2, 2 , .T.) > INSERT INTO REPONDANT ( iid , IRESIDENTID , Lcopy ) VALUES ( 3, 3 , .T.) > INSERT INTO REPONDANT( iid , IRESIDENTID , Lcopy ) VALUES ( 4, 5 , .F.) > SELECT RESIDENT.iid AS 'iresId',; Repondant.iid AS 'irepid'; FROM RESIDENT LEFT OUTER JOIN Repondant ; ON RESIDENT.iid = Repondant.IRESIDENTID; ORDER BY RESIDENT.iid > >BROWSE NOWAIT > > SET > >>
WHERE Repondant.lcopyfact OR Repondant.lcopyfact IS NULL ;There's no need to comapare lcopyfact to .T. because it's a logical value already.
>>>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 >>> >>>