insert into One select * from TwoIn case you only want records that don't exist
create cursor One ; ( pk I ) for i = 1 to 10 insert into One values (m.i) endfor create cursor two ; ( pk I ) for i = 5 to 20 insert into two values (m.i) endfor && add 11 to 20, since 5 to 10 are already in insert into One ; select * from Two ; where not exists (select pk from One where (One.pk == two.pk)) select One brow