The SQL INSERT INTO SELECT Statement
The INSERT INTO SELECT
statement copies data from one table and inserts it into another table.
The INSERT INTO SELECT
statement requires that the data types in source and target tables match.
Note: The existing records in the target table are unaffected. Continue reading SQL INSERT INTO SELECT Statement