Hi


From the Help

Columns referenced in the SQL SELECT statement list, except for aggregate expressions, must be included in the GROUP BY clause. You cannot group by Memo, General, or Blob fields.

think that change came in 7 or 8

Nick

>Hi guys,
>
>It seems like the Group By clause has been changed in version 9.0
>
>Till now I was used to
>
>

Select * from <table name> group by <field name>

>
>It is giving error in ver 9. Any help on that ?
>
>Thanks in advance