>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,
Not sure, I understand your question completely. Do you want to find all records in B, which are not in A and if yes, append them?
select * from B where KeyID not in (select KeyID from A) into cursor curAppend
select A
append from dbf('curAppend')
If it's not broken, fix it until it is.
My Blog