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 01:29
ivan fomin is currently offline ivan fomin
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: Sat Jul 26 07:12:12 EDT 2014

Powered by FUDForum. Page generated in 0.01475 seconds