title: How to implment hibernate IN clause with Criteria?
body: <p>I'm working with hibernate to serach element into database.
  I have yhis sql query to implement with hibernate.</p>
  <pre><code>select * from PRESence presence0
     inner JOIN  AgentMJ agentmj1_ on presence0.FK_AGENTMJ_ID=agentmj1_.PK_AGENTMJ_ID 
     where  agentmj1_.PK_AGENTMJ_ID=18 
     and (presence0.typeContactLibre like 'Absence')
     and agentmj1_.PK_AGENTMJ_ID 
    in (
      select  agentmj1_.PK_AGENTMJ_ID from AgentMJ agentmj1_  
      inner JOIN  Absence absences2_ on agentmj1_.PK_AGENTMJ_ID=absences2_.FK_AGENT_MJ_ID 
      inner join TypeAbsence typeabsenc3_ on 
      absences2_.FK_TYPE_ABSENCE_ID=typeabsenc3_.PK_TYPE_ABSENCE_ID
      where agentmj1_.PK_AGENTMJ_ID=18 and  typeabsenc3_.code =1);
  </code></pre>
  <p>My problem is I can't implement the IN clause using hibernate.
  How to do that? and there is an example to see it?Thanks in advance.</p>