[font="Arial"]

Hello

There are several ways to go about this problem. However, it would help to know if there are any other fields in T2.

For example, does T2 have an identity column? If it does, say it was named rowId. If so you could use the max(rowId) in a subquery to qualify the latest record for a first/last name condition.

Can you give us more information about the T2 table? If it doens't have a identity column, is it permitted to add one to it?

Regards,

Terry

[/font]