Problem is the syntax of the JOIN in the SELECT-SQL statement. You need to specify LEFT, RIGHT, or FULL. The word OUTER is optional but LEFT, RIGHT, or FULL must be specified. The error message is misleading but is evidently a result of the parser not being able to understand the syntax. Same behavior in VFP6, BTW.

>Argh!
>
>I'm using VFP7. I'm creating a cursor, then trying to use it again in a SELECT:
>
>

CREATE CURSOR Attend(Attender C(8))
>
>FOR i=1 TO lnVars
>	INSERT INTO Attend(Attender) VALUES(laAttenders[i])
>ENDFOR

>
>This does indeed create a cursor, with several records - but then:
>
>

>SELECT Attend.*, SchedContribs.UserCode, RECNO('SchedContribs') AS Recordnum ;
>	FROM Attend ;
>	OUTER JOIN .\Extranet\SchedContribs ;
>	ON Attend.Attender=SchedContribs.UserCode ;
>	WHERE SchedCode=lcSchedCode ;
>	INTO CURSOR TQuery
>

>
>Reports: "Alias 'ATTEND' is not found." - Even though my data environment clearly shows a workarea with that name (which I can browse). I've tried using DBF('Attend') instead, with the same results.
>
>Any ideas?
>
>TIA