* Add records to table2 from table1 INSERT INTO table2 ; SELECT * FROM table1 ; WHERE keyfield IS NOT IN ( SELECT keyfield FROM table2) * Add records to table1 from in table2 INSERT INTO table1 ; SELECT * FROM table2 ; WHERE keyfield IS NOT IN ( SELECT keyfield FROM table1)