>select KEYFIELD, CUST_ID as CUSTOMER, ORD_DATE, ORD_TIME ; >from ORDERTABLE ; >where KEYFIELD in ; >(select top 1 KEYFIELD from ORDERTABLE where CUST_ID == CUSTOMER order by ORD_DATE, ORD_TIME descending) >order by CUSTOMER >>
>select ORDERTABLE.KEYFIELD, ORDERTABLE.CUST_ID as CUSTOMER, ORDERTABLE.ORD_DATE, ORDERTABLE.ORD_TIME ; >from ORDERTABLE ; >where KEYFIELD in ; >(select top 1 ORDERTABLE.KEYFIELD from ORDERTABLE order by ORD_TIME ) >>