I have a table StatusLog (LogID, Status, StatusDate) which store history of statuses for each LogID. For example, LogID = 1 will have 2 statuses "Requested" and "Send" (2 records), LogID = 2 can have 3, "Requested", "Send" and "Shipped" (3 records). Ofcourse StatusDate stores corresponded date. I need to find the way to extract current (most recent Status) for each Log. Using MAX(StatusDate) does not produce result if you have Status column in resulting query. Any idea? Thanks