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/
