Selecting Only the first instance of a value?

[chainsawluna]

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???

[stecal]

If you don't care about the variation in names (and why are you sure the addresses are "good" if the names can be so hosed?), then de-dupe the records based on address.

[nosepicker]

If you don't care which name is selected, then how about this:

SELECT MIN(A.name) AS name, B.id, B.otherinfo
FROM table1 AS A JOIN table2 AS B
ON A.id = B.id
GROUP BY B.id, B.otherinfo