>maybe
>
>select RESER_PK, ROOM_NUM as ROOM, RES_DATE, BEGIN_TIME ;
>from RR_RESER ;
>where RESER_PK in ;
>(select top 1 RESER_PK from RR_RESER alias RRR_2 ;
> where RRR_2.ROOM_NUM == ROOM ;
> AND RRR_2.RES_DATE = DATE() order by RRR_2.BEGIN_TIME descending);
> order by ROOM
>
>?
No, changing alias of the RR_SER in the subquery does not help.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham