>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

thanks for the heads up. What about if I wanted to exclude nulls in the ssno field? I wrote is several different ways but it hasn't worked for me:

1:  SELECT strtran(x.ssno,'-',''), x.firstname, x.lastname, x.idnumber, x.archive, y.idnumber, y.imageid ;
	FROM ud_tbl x INNER JOIN it_tbl y ON x.idnumber = y.idnumber AND x.ssno != null ORDER BY x.lastname INTO CURSOR test readwrite

2:  SELECT strtran(x.ssno,'-',''), x.firstname, x.lastname, x.idnumber, x.archive, y.idnumber, y.imageid ;
	FROM ud_tbl x INNER JOIN it_tbl y ON x.idnumber = y.idnumber Where x.ssno != null ORDER BY x.lastname INTO CURSOR test readwrite

both gave me blank cursor table. Must be missing something simple again.

thanks
Nick