Use table2 append from table1 for yourconditionIf you want to add all records which are in table1 and not in table2, into table2, it's easier to find the missing records first
SELECT * FROM table2 WHERE uniqid NOT in (SELECT uniqid FROM table1) into cursor temp Select table2 Append from dbf('temp')You can do all this in one Insert command, but then you must list all the fields.