title: Hibernate criteria api 'Select in'
body: <p>is it possible to create a 'select in'-query with the hibernate critiria api ?</p>
  
  <p>Example :
  I have two tables in a 1:n relation, company and department</p>
  
  <pre><code>select * from company c where c.id in (select company_id from department d 
  where d.departmentname = 'HR' and d.location = 'xyz')
  </code></pre>