Join in HQL

koppy · **Joined:** Tue Dec 27, 2005 1:10 pm **Posts:** 1

Hibernate version: 3.1 (12.12.2005)
Hi hibernators!

I wonder if it is possible to make an outer join in a way like many RDBMS support:

Code:

select user.firstname, user.lastname, address.street  from User user, Address address where user.addressid(+) = address.addressid

Of course I can implement this by a one-to-one mapping but nevertheless
I would like to know if hibernate does/will support those outer joins.

Thanks for a short reply,
Andreas

edward · **Posted:** Fri Feb 24, 2006 1:35 am

hI,

Just refer this link.

http://www.hibernate.org/hib_docs/v3/re ... -outerjoin