SQL Join on Most Recent Record

I have two tables in SQL, table one has information, and table two has more dynamic information that is related to table one.  

Table1
ID
LRSN
INFO
MOREINFO

Table 2
ID
LRSN
DESCRIPTION
LAST_UPDATE

I would like to join the two tables on LRSN, and pull the Description of the most recent Last_Update record from table two.  Can someone help me out with this relationship?  Thanks in advance for the help!
LVL 1
jayh99Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
select ...
from table1 t1
join table2 t2
  on t1.lrsn = t2.lrsn
 and t2.last_update = ( select max(i.last_update) from table2 i where i.lrsn = t2.lrsn )
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT *
FROM Table1 t1
INNER JOIN Table2 t2 ON t1.LRSN = t2.Lrsn
WHERE T2.Last_Update = (SELECT MAx(last_update) from tabel2 where lrsn = t2.lrsn)
0
 
jayh99Author Commented:
Excellent!  Thanks for the quick response!
0
All Courses

From novice to tech pro — start learning today.