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