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