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 = :id1 UNION SELECT t FROM Table t WHERE = :id2 ORDER BY 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:JPA selecting, what should be lazy loaded, when not necessary
Goto Forum:

Current Time: Sun Apr 20 06:49:05 EDT 2014

Powered by FUDForum. Page generated in 0.09614 seconds