ciao ti posto un esempio
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

qui trovi il riferimento alla guida Mysql: http://dev.mysql.com/doc/refman/5.5/...rt-select.html