>Simple scenario. I have a bunch of records and I want to do a SELECT statement grouped on a fields value. I want the result cursor to have the grouped value and the field values for the first occuring record in the group. Problem is VFP 9 doesn't like that kind of SQL Statment, being more ANSI compliant and all. I know I can set the SQL engine to behave like the older versions of FoxPro but I'm wondering if there is a more "policitally correct" way of performing this query?
>
>
>SELECT CompareValue,PriorityCode,UniqueID FROM crsSourceCursor GROUP BY CompareValue
>
James,
You've to define "the first occuring record in the group" in terms of data that has been accessed.
--sb--