Hi Albert,

I think the way it should be handled is that you split the SQL into two different SQL statements. The first one will just have the primary key field and the fields being aggregated, then you join the result of that SQL with the original table to get the other fields that you want.

>Hi Y'all,
>
>I am just updating an app from VFP7 to 9 and knew I would have to deal with the change to the "GROUP BY" part of SQL. I have quite a few spots where I grouped by a single field or two before but now this needs updating. Some SELECT statements have a lot of fields so I don't relish adding all the new fields to the GROUP BY list.
>
>How have some of you handled this?
>
>a) just add them all and quit complaining :-)
>b) write a function to dig out all of the table names in a string and macro expand it (with the original "group by" field first)
>
>I realize that the new syntax is indeed better - I used to have to sometimes sort things in a particular order to get the desired result - because the old way would take the value of a non-grouped field from the *last* record read it seemed.
>
>Thanks,
>
>Albert Gostick