SQL INSERT INTO SELECT Statement

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;