Copying records between FoxPro tables with Insert - possible?

I'd like to do this using an SQL Insert statement, however it doesn't seem
like foxpro supports using Select to generate the values for the Insert
command. Do I have to resort to using two queries and a while not eof...
loop? Any other ways to have foxpro do this for me?

Eivind