>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.
Insanity: Doing the same thing over and over and expecting different results.