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

I have no problems with Russian. But I didn't saw any limns here (I missed them completely).