William,

>I work with SQL server and Fox. Does Fox allow the following Insert Select statement?

No it does not. However you might workarround the problem with:

SELECT ... FROM ... INTO CURSOR X
SELECT Y
APPEND FROM (DBF("x"))

Walter,