>>Hi all
>>
>>This kind of query should be common yet I often seem to break it.
>>
>>Two tables
>>
>>Members, StatusHistory.
>>
>>Status history has the member id the status and the date of the change.
>>
>>I want to grab member info and the current status and change date as of this moment for each member.
>>
>>Please help.
>>
>>Thanks!
>
>Do you mean the maximum date in StatusHistory? If yes, there are several ways:
>

>select * from Members ;
>inner join (select Id, Max(date) from StatusHistory group by ID) as CurrentStatus ;
>on Members.ID = CurrentStatus.ID

>
>Let me write others after the break.

Ha, I see that one more way is already shown by Sergey.

And my favorite one based on the idea of Igor Korolev I'll show later.