--******************* Source NAYCode.com INSERT INTO table1 SELECT col1, col2 , col3 FROM table2 WHERE your condition;