>I need help in selecting records from the following table (simplified):
>
>CUST_ID
>ORD_DATE
>ORD_TIME
>
>For a given date (ORD_DATE), I need to select one order record per customer (CUST_ID) based on the time of order (ORD_TIME). For example, the Order Time should be the latest of the day.
>
>I would appreciate any suggestions.
>
>Thank you.
dGivenDate=DATE()
SELECT * INTO CURSOR Results;
FROM theTable T ;
WHERE ORD_DATE=m.dGivenDate;
AND T.ORD_TIME =(SELECT MAX(ORD_TIME) FROM theTable WHERE ORD_DATE=T.ORD_DATE AND CUST_ID=T.CUST_ID)