Help Developing SQL Query

[byrne1]

I need to create a query that will pull all of the records that are statused as 'OUT' from my RECORDS table and then get the last (chronologically) 'OUT' record from my IN/OUT table for each record it pulled from RECORDS.

I can get the records out of RECORDS without any problems but I don't know how to set up a query that will pull the last chronological 'OUT' record from my IN/OUT table. Is there a way to do this in SQL?

Thank you in advance for any help.

 

[tlbroadbent]

Without specific information - column names, data types, relationships - the best I can do is provide a general answer.
[tt]
Select a.*, b.OutDate
From Records As a
Inner Join (Select ID, Max(OutDate) As OutDate
From InOut Group By ID) As b
On a.ID=b.ID
Where a.Status = 'OUT'[/tt] Terry

http://members.home.net/tlbroadbent/prog.htm

Neither success nor failure is ever final. -Roger Babson