Posted by nigelrivett on 10/16/06 16:41

SELECT v.[ID], Make, Model, [Status], [Status Date]
FROM
[Vehicles] v INNER JOIN [Vehicle Status] vs ON v.[ID] = vs.[Vehicle ID]
and vs.[Status Date] = (select max(vs2.[Status Date]) from [Vehicle
Status] vs2 where vs2.[Vehicle ID] = vs.[Vehicle ID])



www.nigelrivett.net


*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]