Puoi usare la sintassi INSERT INTO ... SELECT: http://dev.mysql.com/doc/refman/5.1/...nto-table.html