>Try
>

>SELECT * FROM Members mb
>  JOIN StatusHistory sh ON sh.MemberId = mb.MemberId
>  WHERE sh.ChangeDate = (SELECT MAX(ChangeDate) FROM StatusHistory WHERE MemberId = sh.MemberId)

Yes! Seems simple when you do it. :)

>
>

>
>>
>>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!