hi,

in tutorials i find only left joins betweet Entities which are already connected
(from Cat as cat left join cat.mate.kittens as kittens)

is it possible to join arbitrary Entities?
from A a left join B b on a.x = b.y

is this possible
from A a left join B b on a.x = b.y

Hi,


For me the following does not work:

select a from A as a left join B as b on a.x = b.x

I get an exception like :

org.hibernate.hql.ast.QuerySyntaxError: unexpected token: on near line 1, column (whatever column is "on" on)

Any ideas or clues would be highly regarded.

That is clasical sql.
In hql it would be something like this:
Select a1 from A a1 outer left join a1.b as b1

but my idea was to join tables which are only linked in database but not in models mapped by hibernate which is not possible at least not easily possible .
but I've decided to change my approach so I do not have that problem any more.

Kruno.