That's the job of
INSERT INTO SELECT statement.
Syntax:
INSERT INTO table2
SELECT * FROM table1;
OR
INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;
Example:
INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers;
Reference:
SQL INSERT INTO SELECT Statement[
^]
Hope, it helps :)