Fabio,

There is a benefit - the fact of adding/removing GROUP BY or DISTINCT clause does not modify meaning of the ORDER BY clause.

If I remember correctly, you were so anxious to have similar benefit with the syntax for correlated UPDATE (thread #989905). I wonder what is the reason for your inconsistent position? Is it an opportunity to call something a bug?

Thanks,
Aleksey.

>Aleksey,
>
>If in the grouping case ( DISTINCT or GROUP BY )
>it is not possible to order to the results for a tablesource's field,
>why VFP search the ORDER BY name in the list of the fields of the table source?
>It does not have sense.
>This creates alone problems in the construction of the query, without benefits.