INSERT INTO
    `some_table` (`fld1`,`fld2`,`fld3`)
SELECT
    `some_table2`.`fld1`,
    `some_table2`.`fld2`,
    `some_table2`.`fld3` 
FROM
    `some_table2` 
WHERE
    `some_table2`.`fld` > 100;