INSERT INTO table_name(column_list) SELECT select_list FROM another_table WHERE condition;
INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition;
INSERT INTO table2 SELECT * FROM table1 WHERE condition;