How to deal with: left outer join ( A join B on xxx ) on yyy

smougenot · **Posted:** Fri Sep 12, 2008 12:16 pm

Hibernate version: 3.2.5

Im trying to figure out how to write a HQL query generating a SQL like ;

Code:

select T.key, B.key from T left outer join ( A join B on xxx ) on yyy

(the key property is just an sample; I actualy get a name and a number of documents for a report)

Context
The aim is to have access to this structure :
T : the "master" table
A : is associated to Tabe but not mandatory (in T)
B : is associated to A

The path si something like
T -> A -> B
I need to get the Object from T and from B (or null)

I tried many HQL, they all failed.
ex:

Code:

select T.key, B.key from T left join (t.a A join A.b B with xxx) with yyy

Questions
Is it a kind of sql query that Hibernate can generate?
How to write the correcponding HQL?[/code]

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

As far as I know, "Common table expressions" (CTE) and the WITH keyword are not supported in Hibernate.

You can probably achieve the same result by using a subquery, or by joining all the involved tables at the same level.