Transferring Columns With SQL

INSERT INTO  mytable2 (column1, column2, column3, ...)
SELECT  column1, column2, column3, ...
FROM mytable1
WHERE condition;