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 ***

• Next in forum: Re: automated role creation
• Prev in forum: Re: SQL Batch - Slow Response - Remote DB query
• Thread view: Re: Related Tables: Help Needed With JOIN Query

[Reply to this message]