Merging two tables

[Guest]

I have two tables, both with identical fields (imported from two
spreadsheets). Both tables have data in field1 (UserName); table 1 has data
in fields 2 - 6, whilst table 2 has data in fields 7 - 11

How do I merge the two tables togeather, so that record 1 contains the data
from fields 2 - 6 AND tables 7 - 11? (asuming that the UserName is identical?

Many thanks in advance

 

[Neil Sunderland]

I have two tables, both with identical fields (imported from two
spreadsheets). Both tables have data in field1 (UserName); table 1 has data
in fields 2 - 6, whilst table 2 has data in fields 7 - 11

How do I merge the two tables togeather, so that record 1 contains the data
from fields 2 - 6 AND tables 7 - 11? (asuming that the UserName is identical?

The SQL will be something like this:
SELECT
Username,
Field1, Field2, Field3, Field4, Field5, Field6,
Field7, Field8, Field9, Field10, Field11
FROM
Table1
INNER JOIN
Table2 ON Table1.Username = Table2.Username

 

[Guest]

--
Keith W

The SQL will be something like this:
SELECT
Username,
Field1, Field2, Field3, Field4, Field5, Field6,
Field7, Field8, Field9, Field10, Field11
FROM
Table1
INNER JOIN
Table2 ON Table1.Username = Table2.Username

--
Neil Sunderland
Braunton, Devon

Please observe the Reply-To address

Neil, It worked a treat, and first time too.

Many thanks