>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
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing