SELECT * ; FROM curFirst cf1 ; WHERE Field3 ; IN ( SELECT MAX(field3) FROM curFirst cf2 ; WHERE cf2.field1 = cf1.field1 ; AND cf2.field2 = cf1.field2); INTO CURSOR crsResult>>You can do this in two steps
SELECT field1, field2, MAX(field3) AS max3 ; >> FROM curFirst ; >> group by Field1, Field2 ; >> INTO CURSOR crsTemp >> >>SELECT * ; >> FROM curFirst ; >> WHERE STR(Field1) + STR(Field2) + STR(Field3) ; >> IN ( SELECT STR(Field1) + STR(Field2) + STR(max3) >> FROM crsTemp ); >> INTO CURSOR crsResult>