>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.
If it's not broken, fix it until it is.
My Blog