Joining two tables over a compound index in Hibernate

Question

I have

Entity A - type - uniqueKey

and

Entity B - uniqueKey

and i dont know how to integrate it into hibernate that i can produce results like from this query:

select * from A left join B on B.uniqueKey = A.uniqueKey and A.tpye = 1 where A.id is null

this will produce a result that has all the entries of B that are not in A for type = 1.

i know that i can just use a native query, but i would like to see a different solution.

Answer 1

I asked a similar question 2 days ago

http://stackoverflow.com/questions/1302159/hql-bug-and-nullable-fields

take a look.