select RESER_PK, ROOM_NUM as ROOM, RES_DATE, BEGIN_TIME ; from RR_RESER ; where RESER_PK in ; (select RESER_PK from RR_RESER where ROOM_NUM == ROOM ; AND RES_DATE = DATE()) order by ROOMHTH
>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 where ROOM_NUM == ROOM ; >AND RES_DATE = DATE() order by BEGIN_TIME descending) order by ROOM >>The error I get is:
>Command is missing required clause>The RESER_PK is a PK field.