insert into select statement

SQL INSERT INTO SELECT statement selects data from one table and insert it into another table.