Magari ho capito male ma forse ti basta una insert into select.

http://dev.mysql.com/doc/refman/5.0/...rt-select.html