title: Hibernate "IN" clause as ALL instead of ANY
body: <p>I'd like to start by apologizing for my unfamiliarity with Hibernate.  I'm only recently getting into it and am far from an expert.</p>
  
  <p>I have three tables:  Contract, Products, and a link table between them to define a many to many relationship.</p>
  
  <p>I'm trying to write an HQL query to return all contracts that contain a <em>range</em> of products.  Unfortunately, the <code>IN</code> syntax works like an <code>Any</code> instead of an <code>All</code>.  So if I want all contracts that have ProductA, ProductB, and ProductC, the <code>IN</code> keyword will return me contracts that have any individual one of those products, instead of contracts that have all of them.</p>
  
  <p>How should I structure my HQL query? </p>