Thank you John..
Gerhard
>>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
>
>Best to leave off the F5 memo in the initial SQL and replace it with the key field that points to it and also add an empty memo field
CAST(SPACE(1) AS M) AS F6
. Then update the result cursor/table F6 field from the source using the key field. At least that's the way I do it. And yes, only use use the latest version of SQL.
Gerhard Schmidbauer
URANUS Software GmbH