SQL: Copy Data From One Table Into Another
Join the DZone community and get the full member experience.Join For Free
// SQL Query to copy data from one table and insert it into another
INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1
Opinions expressed by DZone contributors are their own.