The moose likes Object Relational Mapping and the fly likes UNION Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "UNION" Watch "UNION" New topic


Nitin Dindorkar

Joined: Nov 14, 2003
Posts: 6
Can some one pl tell me what is HQL equivalent of a UNION.
I want to do UNION of 2 select queries how shouls i do it in HQL?
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

There isn't an equivalent. You could use a SQL query to achieve it though. Or just use two queries.
[ March 02, 2006: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
It is sorta covered in the JavaRanch Style Guide.
subject: UNION
Similar Threads
how to use UNION function in HQL?
Does HQL support UNION (or INTERSECT)?
Hibernate Doubt in HQL
subquery sql to hql
hibernate delete performance