Assuming all the 3 tables have identical fields, say field1 and field2, except the primary keys if any,
INSERT INTO table1 (
SELECT * FROM table3 t3 WHERE NOT EXISTS (
(SELECT * FROM table1 t1 WHERE t1.field1=t3.field1 AND t1.field2=t3.field2)
OR
(SELECT * FROM table2 t2 WHERE t2.field1=t3.field1 AND t2.field2=t3.field2)
))