I seem to be stuck between a rock and hard place. I currently have two unrelated (as far as Hibernate is concerned) tables, users, and user_role, and am using the following HQL query for a theta-style join:

select distinct user, ur.roleName from User user, UserRole ur where user.username=ur.username

This works fine except it's an inner join, and I want to return users even if they have no roles. So in SQL this would would trivial to do as a left outer join, but as far as I can tell HQL doesn't support theta-style outer joins.

I also appear to be unable to do this using a
named <sql-query> element, as that expects to only return one class, and I also need the roles.

Do I have no choice here other than introducing a Hibernate relation?

Regards,
Colin

I am also facing similar situation.

I have two tables A & B, not related w.r.t. hibernate. I want List of Object[] where

Would work fine for inner join as:

But, seems outer join(left/right/full) are not allowed.