SQL Select

[××•×¨× ×” בן ×רי]

Hi,

I have a table for the statuses of orders with the following fields:
id,StatusId,StatusChangeDate.
How do I retreive records grouped by Id (Order ID) with the last change date?
In my query I also need the StatusId of the record found.

Thanks,
Orna.

 

[Allen Browne]

Use a Subquery to get the ID of the matching records, sorted by Date
(DESCending) and ID.

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

If subqueries are new, here's an explanation:
http://allenbrowne.com/subquery-01.html

 

[Orna]

Thanks, this is exactly what I was looking for.

Orna.