>Maybe it must be:
>

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

No, it should not. Can you read Russian? If yes, just read the link referenced in this thread carefully, it has all the explanations. Also referenced thread in tek-tips has similar explanations by Olaf, but in Einglish.