>The first statement works. The second returns "SQL: GROUP BY clause is missing or invalid." How could this be?
>
>
>SELECT LastName FROM Agent GROUP BY Lastname
>SELECT * FROM Agent GROUP BY Lastname
>
Jay,
You've to include all non-aggregate fields into GROUP BY.
It's documented in VFP8 help under
Behavior Changes Since Visual FoxPro 7.0 and in
INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #
813361.
--sb--