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)

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