Correlated Sub query - Sample

SELECT Id, Status_Date,Status_Description FROM T1612_INV_STATUS [ST]
WHERE Status_Date = ( SELECT Max(Status_Date) FROM T1612_INV_STATUS WHERE [ST].Id = Track_Id)