title: HQL and one-to-many queries
body: <p>I have Hibernate domain objects that looks like this:</p>
  
  <pre><code>   class Player {
        List&lt;Item&gt; inventory;
     }
  
     class Item {
        List&lt;Enchantment&gt; enchantments;
     }
  
     class Enchantment {
        boolean isSuperiorEnchantment;
     }
  </code></pre>
  
  <p>I need to construct an HQL query that returns to me a list of all players that have at least one item with an enchantment on it that has the <code>isSuperiorEnchantment</code> flag set.  I can't for the life of me figure out a way to express this in HQL.</p>
  
  <p>Any ideas?</p>