HQL inner join on a primitive type

lucsto · **Joined:** Fri Jul 07, 2006 9:51 am **Posts:** 9

Hibernate version:3.1.3

Hello everybody :

In HQL, is there a possibility to do a join in on 2 entities (classes) without one being member of the other ?

I looked through the Hibernate examples and seems that always the examples have something like "from Product p inner join fetch p.categories"

I only need to show a product having a certain category without having Category a data member of product.

Well, <join> tag would have made the business but it can only join on the primary key of the first table...

Thank you
Lucian

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

You can use theta-style "cross" joins to do this:

Code:

select a.val1, b.val2
from A a, B b
where a.JoinCol = b.JoinCol

Note that <join> does not require joining on the primary key of the first table: use <key column="colInTable2" property-ref="propInEntity1"/> to use a non-ID property.

lucsto · **Joined:** Fri Jul 07, 2006 9:51 am **Posts:** 9

Thank you for your reply.

However

http://opensource.atlassian.com/project ... se/HHH-551
http://opensource.atlassian.com/project ... e/HHH-1829

the property-ref is not taken into account in the join tag.