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