Try,

...
UNION ALL ;
SELECT PROJECTS.PROJID,;
	PROJECTS.PROJ_NAME,;
	SPACE(254) AS CSNT_NOTE;
	FROM CONSULT, PROJECTS,CONSLIST ;
	WHERE PROJECTS.PROJID = CONSLIST.PROJID ;
		AND CONSLIST.CONSKEY  =  CONSULT.CONSKEY ;
		AND (PROJECTS.PJ_STATUS="ACQ-CONTRACT" ;
		AND (CONSLIST.TYPE="CNS" ;
		OR (CONSLIST.TYPE="GPX"));
		AND PROJECTS.PACQASSOC="SFG") ;
		AND CONSULT.CONSKEY NOT IN ( SELECT CONSKEY	FROM CNS_NOTE) ;
...		

You'll have to replace 'SPACE(254) AS CSNT_NOTE' with something compatable with the first select. Take a look also at http://support.microsoft.com/default.aspx?scid=kb;en-us;124589.

BTW, it's very hard to read code where everything is UPPER (or lower) case.

>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.
>