INSERT INTO table2
SELECT * FROM table1
WHERE condition;

veya

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;