See
Re: Proper syntax for creating sub-queries Message #
1334272>
>I tried two or three times to use a SELECT SQL instruction and I had problems witn GROUP BY parameter.
>
>I had to use anothers instructions to do the same i wanted to do witn SELECT SQL
>
>But now I copyied exactly a SELECT SQL instruction from other form that worked very well on VFP 6.0 and "GROUP BY" fails again
>
>I can't paste the instruction here but anyone knows if "GROUP BY" has a new syntax?
>
--sb--