INSERT INTO SELECT statement copies data from one table inserts it into new table In INSERT INTO SELECT statement datatype and column names should matches while copying from one table to another table