>Is it possible to create a cursor from a SQL SELECT and then APPEND FROM to an existing table?

Sure

SELECT * FROM table INTO CURSOR mycursor NOFILTER
SELECT anothertable
APPEND FROM (DBF("mycursor"))

You could also SELECT ... INTO ARRAY then APPEND FROM ARRAY instead - depending on the size of the returned data set.