INSERT INTO tablename(select colnames from tablename)
INSERT INTO destination_table (column1, column2, column3) from (select column1, column2, column3 from source table);
INSERT INTO Table1 (FirstName, LastName) SELECT FirstName, LastName FROM Table2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)