Hi Nick,

Looks like you are missing a comma after x.lastname
Those error messages on SQL are soooo helpful!

Bruce

>I am trying to join two tables by idnumber and create cursor at same time in vfp7 and I keep getting error saying

Command contains unrecognized phrase/keyword.

>
>here is the statement I using:
>

SELECT x.ssno, x.firstname, x.lastname x.idnumber, y.idnumber, y.imageid ;
>	FROM ud_tbl x INNER JOIN it_tbl y ON x.idnumber = y.idnumber INTO CURSOR test

>
>It has been awhile since I've used foxpro so forgive me if anything that looks obvious.
>
>thanks
>Nick