Okay I'm in the process of cleaning up some very large address lists. Individuals have their names spelled several different ways, however the address are good. I need to create an internal list for of their names and address [their must be a name value]. The issue I have is that I need to select a single value out (without preference) from several out of a table.

Here is an example

Table 1.
Jim, 1
Jimm, 1
Amy, 2
Amee, 2

Table 2.
1, Someotherinfoabout1
2, someotherinfoabout2

Wanted Result:
Jim, 1, Someotherinfoabout1
Amy, 2,someotherinfoabout2

I've been trying to find the SQL to do this all day, Any suggestions???