Mel,
Here is the thread of interest
GROUP BY 1 no longer works Thread #
750415 Message #
750415(I searched by 1 as User ID and Select ANSI as keywords)
>>No, unfortunately it's no longer correct way (or never was correct way). It >works in VFP7 and bellow, but would not work in VFP8. It also would not >work in SQL Server or Access.
>
>Thanks for the heads up on this - as I don't want to revisit this code when I move to VF8 in a couple months. In the past I would build a temp unique index to handle this type of situation, and perhaps that is still my best solution.
>
>Mel Cummings
If it's not broken, fix it until it is.
My Blog