pzmrcd (6/13/2008)
But for some recs in T1 there are multiple matching T2 rows.In this case I would like to get the info from the last record in T2.
Define "last".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]