>Hello,
>
>I have a SQL Select that does not work. I get "Missing or illegal GROU BY Clause".
>
> SELECT F1, F2, F3, F4, F5 ;
> FROM TAB1 ;
> INTO TAB2 ;
> ORDER BY F1, F2, F3, F4 ;
> GROUP BY F1, F2, F3, F4
>
>F5 is a memofield. So I can not include it in the GROUP BY.
>How can I have the result grouped by the rest of the fields?
>
>TIA
>Gerhard
Hi Gerhard,

Try SET ENGINEBEHAVIOR 70

Hope this helps,

Ken