Skip to main content

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 = :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:MappedSuperclass methods not getting weaved
Goto Forum:

Current Time: Sun Apr 05 23:41:08 GMT 2020

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

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

Back to the top