INSERT INTO tablenamedest (col1, col2, col3)
SELECT col1, col2, col3
FROM tableSource