Yes you can.
selec * from mytable into cursor mycursor
select table1
append from mycursor
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E