Terry

I like the copy structure extended approach - it clearly identifies the duplicates - looks great - thanks very much

Colin

>You could also "COPY STRUCTURE EXTENDED" for each DBF you are using and the APPEND the extended structures into one file.Then issue a create from to create one DBF.
>
>>>This may work for you:

SELECT * FROM TableA INNER JOIN TableB ON TableA.MyPK = TableB.MyPK INTO TABLE TableC

If two fields have the same name, they will be renamed. For example TableA.MyPK and TableB.MyPK will be renamed MyPK_A and MyPK_B respectively.
>>>
>>>HTH
>>>
>>>>What is the best way to merge the structures of 2 tables and what happens when fields on both tables have the same field name?
>>
>>Thanks I'll try it