>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