Hi All,

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

Aloha,

James