Thank you thank you thank you. How did you find out about this set enginebehavior? Has this been talked about before (I just joined UT)? I freaked out because our system uses group by in several places to get unique values ie:

We have an appointdetail table containing IAPPTID which relates to the IID field in appointheader. One place we simply wanted a listing of all unique IAPPTID records and the DDATE field of each (same date across all same IAPPTID records).

SELECT appointdetail.* FROM appointdetail JOIN ON appointheader.iid = appointdetail.iapptid INTO CURSOR mycursor GROUP BY iapptid

This worked fine if fox 7 and as you know dies in fox 8 with GROUP BY invalid or missing.

I can't get any group by to work if it includes fields that are not in the group by clause.

Again, thanks.

John