INSERT INTO SELECT Statement in sql

The INSERT INTO SELECT statement selects data from one table and inserts it into an existing table. Any existing rows in the target table are unaffected.

SQL INSERT Syntax

The syntax for the SQL INSERT statement when inserting a  record using the another table.

INSERT INTO table
(column1, column2, ... )
SELECT expression1, expression2, ...
FROM source_table
WHERE conditions;

SQL INSERT INTO SELECT Examples

Copy only a few columns from another table......

INSERT INTO suppliers
(supplier_id, supplier_name)
SELECT account_no, name
FROM customers
WHERE city = 'Newark';