SQL – Copy Data From One Table Into Another

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