File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
I agree. Here's the link:
subject: UNION
It's not a secret anymore!