>>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).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.