Hello all.
I need help running this on Foxpro 2.6W( 2.6 does not understand INNER/LEFT/RIGHT e.tc. joins).

SELECT PROJECTS.PROJID,;
PROJECTS.PROJ_NAME,;
CNS_NOTE.CSNT_NOTE;
FROM CONSULT, PROJECTS,CONSLIST,CNS_NOTE;
WHERE PROJECTS.PROJID = CONSLIST.PROJID ;
AND CONSLIST.CONSKEY = CONSULT.CONSKEY ;
AND CONSULT.CONSKEY = CNS_NOTE.CONSKEY ;
AND (PROJECTS.PJ_STATUS="ACQ-CONTRACT" ;
AND (CONSLIST.TYPE="CNS" ;
OR (CONSLIST.TYPE="GPX"));
AND PROJECTS.PACQASSOC="SFG") ;
INTO CURSOR VPDEALS6

The above statement works fine. But I also need all the record from CONSULT that doesn't have a match in CNS_NOTE table. I'm trying to use a UNION statemet but I can't get it to work properly.

Please help if you can.

Thanks