How to join PK / FK columns using HQL?

Question

Using HQL, how do you join columns (or object properties) that are not PK / FK?

I am reading the docs and it seems like it is implicitly going to join the PK columns correctly?

+1

yogurt May 19 '09 at 14:16

2 answers

Stefan steinegger · Answer 1 · 2009-05-19T14:26:55+0000

HQL is attached "implicitly" to foreign keys. If you don't have a (mapped) relationship, just make a Cartesian product and join the where clause.

select order.id
from Order as o, Product as p
where o.productKey = p.Key

Taran singh · Answer 2 · 2010-03-06T13:19:30+0000

select order.id from Order as o, Product as p where o.productKey = p.Key

This will be an inner join, is there a way I can make the left outer using an implicit join.