As a last resort, you can use SET ENGINGEBEHAVIOR 70 to make it use the vfp7 sql syntax.

Alan

>Hi Sergey,
> That's an interesting idea, but it might not give a complete row. It could give some columns from one row and some columns from another row. I don't care which row it gives, but it has to be a complete row, that is, all the columns must come from a single row.
> Is there any other way to get around the GROUP BY constraint?
> Thanks, Chaim