Hi guys, thanks for taking a look.

I have two tables in SQL 2005, let's say Name and Address. Name has the columns 'NameID' 'FirstName' and 'LastName'. Address has 'NameID' 'Line1' 'Line2' and 'LastConfirmed'.

What I want to do is

select FirstName,Lastname,Line1,Line2 from Name a
join Address b
on a.NameID = b.NameID

But I only want the most recent record in the Address table to be returned, based on something like 'order by LastConfirmed desc'. Any ideas how to do this?

Restrictions:
1. The table I am working with cannot be modified/columns added.
2. No additional permanent tables can be created.

Thanks!