>There is a new setting that fixes that problem. It makes your data engine work like VFP 7.
>
>

SET ENGINEBEHAVIOR 70

Yes, I know. However, I don't mind making the SQL to work to be fully compliant with VFP own default. I would like to know which change I should do. So far, the only way I can make a GROUP BY 1 to work is to remove all the fields and only keep one. Can someone explain that? That is when being used in a UNION. However, if I don't have a UNION clause, in order to make the GROUP BY to work, when having multiple fields, I have to use the naming field instead such as GROUP BY Member.Numero.