>>Bill,
>>Let's assume there is a unique key, UniqKey,
>>or some other way of positively identifying which
>>records in table1 are not in table2.
>>Try this:
>>
>>select * from table1 ;
>> where UniqKey not in ;
>> (select UniqKey from table2) ;
>> into cursor toappend
>>select table2
>>append from dbf('toappend')
>>
>>Good Luck,
>>Dore
>>
>>> have two identical tables in different directories. The
>>>data in the first table changes monthly and I will update
>>>the second table from it. I used a set relation statement,
>>>replace field data, etc. I also want to append records from the
>>>first table to the second table when there is no matching
>>>record in the second. I'm considerin a scan..endscand with
>>>an if statement based on a seek on the indexed field. Is
>>>there a better way? Some kind of SQL update maybe?
>
>
>You don't even need that:
>
>SELECT * FROM table1 UNION (SELECT * FROM table2) INTO TABLE combined
>
>If you leave the ALL off of the UNION you only get records that are different.

An excellent solution.