union « SQL « JPA Q&A

1. Hibernate Union alternatives    stackoverflow.com

What alternatives do I have to implement a union query using hibernate? I know hibernate does not support union queries at the moment, right now the only way I see to ...

2. Is there an alternative to using UNION in this SQL statement, using Hibernate 3?    stackoverflow.com

I've got a nasty query which joins three different queries. I don't think there's any Hibernate way to handle unions (we're using Hibernate 3.0.5), so the statement is written as an ...

3. SQL Union: Newbie Question    forum.hibernate.org

Hello I'm new to Hibernate and want to know if it is possilble to use the SQL "union" function in HQL. I didn't find any related documentation. Here an example: SQL: select datum, sum(Betrag) from ( select valutahaben as datum, sum(Betrag) from buchungssatz where haben like '%1' group by valutahaben union select valutasoll as datum, - sum(Betrag) from buchungssatz where soll ...

4. how to use SQL union or minus in hibernate ?    forum.hibernate.org

5. Native SQL UNION sample code please    forum.hibernate.org

6. Using UNION on sql    forum.hibernate.org

7. UNION in native SQL    forum.hibernate.org