This post shows you how to use SQL INSERT INTO SELECT Statement to another table.
INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;
For example
INSERT INTO Customers (CustomerName, City, Country)
SELECT Name, City, Country FROM Persons;