我有一个复杂的数据库,看起来像这样:
product *1 <-> n* inventory *n <-> 1* inventoryUser *1 <-> n* user
现在我想在HQL中查询所有用户的产品,其中用户的名字为“peter”。
Product as p join fetch p.inventories as i join fetch i.inventoryUser as iu join fetch iu.user as u where u.name=:name
SELECT p FROM Product p, IN(p.inventory.inventoryUser) AS iu
WHERE iu.username=:username