INSERT INTO table2 (column_name1,2,3..) SELECT column_name1,2,3..) FROM table1;
INSERT INTO table1 (col1, col2, col3) SELECT Col1, Col2, Col3 FROM table2
SELECT * INTO newtable --any new talbe name FROM table1;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)