2 tables, having separate hibernate config, how can I write an HQL to do outer join?

select A, B
from BeanA as A left outer join BeanB as B
on A.id=B.id

The above HQL doesn't work.

Please help!

I am assuming you have a relationship defined for them (since there is or you would not have joined them (one-2-one).

select A,B from BeanA as A left outer join A.beanB as B


but you could drop the select A,B [and as B] so its starts with the from since you can get B from A. Since it s a one-2-one you could have it setup so a session.load() get it them as well. Once again B is avaiable from A.