*
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
Author

UNION

Nitin Dindorkar
Greenhorn

Joined: Nov 14, 2003
Posts: 6
Hi
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?
Regards,
Nitin
Paul Sturrock
Bartender

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