Seems like this has worked hit and miss for me in the past. When in doubt I always use

Select * from tableA into cursor test NO FILTER

Select whatever from test into cursor test2.

check out NO FILTER in vfp help (under Select -SQL) for a brief explanation. It isn't that clear to me why this is needed, but maybe it's clearer to others.

>John ---
>
>What are your two SELECT statements? I just tried the following with no problem:

>SELECT * FROM mytable INTO CURSOR xxx        && Base table to cursor
>USE IN mytable                               && Closes base table
>SELECT * FROM xxx INTO CURSOR yyy            && Cursor to cursor

>
>
>>I always though I was able to create a SQL cursor (read-only) based on previously created SQL cursor (read-only) but I guess not. I get an error something like "Must SELECT...INTO TABLE" on the second attempt. Thus, I have to do USE DBF("cursor") AGAIN... before the second SQL-SELECT statement. Any reason why?