SELECT Cl_Ref, re_date, MIN(R.Re_Time) ; > FROM Referral R; > WHERE BETWEEN(DTOS(R.Re_Date), "20010101", "20010201"); > GROUP BY Cl_Ref, Re_Date > INTO CURSOR Minimums NOFILTER > >SELECT *; > FROM Referral; > WHERE BETWEEN(DTOS(Re_Date), "20010101", "20010201"); > AND DTOS(re_date) + Re_Time = (SELECT DTOS(re_date) + min_re_time ; > FROM Minimums; > WHERE Minimums.Cl_Ref = Referral.Cl_Ref) ORDER BY Cl_Ref >>
SELECT Cl_Ref, MIN(R.Re_Time) ; >> FROM Referral R; >> WHERE BETWEEN(DTOS(R.Re_Date), "20010101", "20010201"); >> GROUP BY Cl_Ref, Re_Date >> INTO CURSOR Minimums NOFILTER >> >>SELECT *; >> FROM Referral; >> WHERE BETWEEN(DTOS(Re_Date), "20010101", "20010201"); >> AND Re_Time = (SELECT min_re_time ; >> FROM Minimums; >> WHERE Minimums.Cl_Ref = Referral.Cl_Ref) ORDER BY Cl_Ref >> >>>>