INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition;
INSERT INTO table1 (emp_id, fname) SELECT emp_id, fname FROM table2 WHERE status = 'Active';