The SQL INSERT INTO SELECT Statement is used to copies data OR add one record OR row to a table and insert copies data OR record into another table.
SQL INSERT INTO SELECT SYNTAX EXAMPLE:
INSERT INTO table_name_2
SELECT * FROM table_name_1
WHERE condition;
****************OR****************
INSERT INTO table_name_2 (column_1, column_2, column_3, ...)
SELECT column_1, column_2, column_3, ...
FROM table_name_1
WHERE condition;