linking tables

[Guest]

I have a table with fieldname initials and a second table with fieldnames
initials and name.
How do I get name from the second table into a query containing data from
the first table?

 

[Guest]

SELECT Table2.Name
FROM Table1 INNER JOIN Table2 ON Table1.initials = Table2.initials