Skip to main content



      Home
Home » Eclipse Projects » EclipseLink » using UNION with ORDER BY clause
using UNION with ORDER BY clause [message #1220005] Mon, 09 December 2013 01:29
Eclipse UserFriend
Im using eclipselink 2.5.1 when i try to execute query like this: "SELECT t FROM Table t WHERE t.id = :id1 UNION SELECT t FROM Table t WHERE t.id = :id2 ORDER BY t.name ASC" i get exception "Syntax error parsing". Query only with UNION or ORDER BY works fine. Is it possible to sort result of union query?
Previous Topic:Run time error for DALI generated entity with compound keys
Next Topic:MappedSuperclass methods not getting weaved
Goto Forum:
  


Current Time: Tue Jul 08 02:54:39 EDT 2025

Powered by FUDForum. Page generated in 0.06719 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top