OK, sorry, forgot to name the inner table (x):
SELECT * FROM (your_SELECT_with_GROUP_BY) x ORDER BY ...
On 29.6.2007, at 10:28, Dmitri Pissarenko wrote:
Hello!
On 6/28/07, Peter Ondruska <[EMAIL PROTECTED]> wrote:
SELECT * FROM (your_current_SELECT_statement_with_GROUP_BY) ORDER
BY ...
Thanks for your answer!
When I do this, I'm getting this error:
SQL State = 42X01 SQL Code = 30000 SQL Message = Syntax error:
Encountered "ORDER" at line 5, column 1. Exception message =
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at
line 5, column 1.
Best regards
Dmitri Pissarenko
--
http://www.xing.com/profile/Dmitri_Pissarenko
http://dapissarenko.blogspot.com/
