Hi,
May try SQL, e.g. select * from tableb where fd1+fd2+fd3 not in;
(select fd1+fd2+fd3 from tablea) into cursor new_recs
Then append it from the cursor. But if there are many fields with different data types then it may not be a good idea.
With Oracle, it'd be better, insert into tablea select * from tableb;
where (fd1,fd2,fd3) not in (select fd1,fd....)

Wilfred

>Hi All,
> I have one table (table A) that has the data I want to compare with another table (table B). I was thinking of using the scatter memvar command in table A and scanning through table B. If there were records that I had missed or were unique I would append them into table A from table B. Has anyone done this before? Is there a better way to compare data in two tables?
>Thanks,