smadin <[email protected]> writes: > I use UNION ALL to join these statements. But my problem is, sql exception > is thrown saying that there is a problem in ORDER clause when statements are > separated using parentheses. > " java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at > line 1, column xxx."
Hi smadin, Which version of Derby are you using? ORDER BY in operands of UNION ALL was not supported until very recently, in version 10.10.1.1. -- Knut Anders
