>>* Using subquery >>SELECT driver_id, status, updt ; >> FROM temp2 ; >> WHERE driver_id + DTOS(updt) IN ( ; >> SELECT driver_id + DTOS(MIN(updt)) ; >> FROM temp2 ; >> GROUP BY driver_id) ; >> INTO CURSOR crsResult >>* Using correlated query >> >>SELECT driver_id, status, updt ; >> FROM temp2 tm1 ; >> WHERE updt IN ( ; >> SELECT MIN(updt) ; >> FROM temp2 tm2 ; >> WHERE tm2.driver_id = tm1.driver_id) ; >> INTO CURSOR crsResult >>>>