I ran the two first selects and I see the problem.

In the StatusHistory table we should have a PK, say, StatusID.

The code should be

SELECT Mb.*, Sh.* ;  
  FROM Members mb ;  
  INNER JOIN StatusHistory sh ON Mb.MemberId = sh.MemberId ;  
  WHERE sh.StatusId IN ;  
          (SELECT CTOBIN(RIGHT(MAX(DTOS(ChangeDate)+BINTOC(StatusId )),4)) ;  
              FROM StatusHistory GROUP BY MemberId )

That's what happens when you write code based on a sample :)

You're a cheater by not creating PK in StatusHistory :)