title: hql in-clause with multiple hits in child collection
body: <p>I have a table/entity called <code>Recipe</code> with a child collection of type <code>Tag</code>.
  I want to be able to find a Recipe searching by two or more tags. Something like:</p>
  
  <pre><code>SELECT re FROM Recipe re JOIN re.tags t WHERE t in :tagsIds
  </code></pre>
  
  <p><strong>but I only want those hits where the Tag collection contains all tagIds.</strong>
  Is it possible in HQL/SQL? (Maybe using Criteria?)</p>
  
  <p>Thanks in advance.</p>