Hi, Hibernate gurus,
I have a query upon Part and Inventory. Every part may have its inventory info consists of
part, warehouse, stocklocation and quantity as minimum. Part has a property bLevel.
Now I want to find all parts whose inventory is below its bLevel. If a part has no inventory
entry in database, its inventory's quantity is zero. So we need out join.
But since Part has no association to Inventory. I don't how to write such HQL. And I wonder
whether it's possible to join two independent entities in HQL?

Are there any alternatives or work-arounds?

Thank you very much!

Justine

It is possible to write an _inner_ join in theta style (ie. a traditional where-clause join). It is not possible to do an outer join on an arbitrary condition, except using createSQLQuery().

Hi, gavin

I understand. Thank you very much!