>>>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
>
>No, NO, NO! That's about the worst advice you can give someone. Cyanide is even quicker!
>
>Please read what Help says about Set Enginebehavior, including the warnings!

OK. I should have added a warning to check the help file. But it would work and I don't think it would kill him.

Ken