Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » using UNION with ORDER BY clause
using UNION with ORDER BY clause [message #1220005] Mon, 09 December 2013 06:29
ivan fomin is currently offline ivan fominFriend
Messages: 1
Registered: December 2013
Junior Member
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: Fri Nov 28 23:22:26 GMT 2014

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

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