Unfortunately, near as I can tell the reason for the differences on the Group by clause is that VFP differs slightly from the Ansi SQL standard.

SQL Server Group by functions the same as Oracle, according to the standard.

PF

>John
>
>SQL Server does allow the "distinct" keyword which will solve the issue.
>
>There are quite a few differences between SQL server and VFP regarding Group, some of which make no real sense to me... but that is a different issue.
>
>Regards
>
>JR