title: Hibernate Critieria join two tables with condition on 2nd table and result the 1st table
body: <p>I have a question using Hibernate Criteria, I need to convert this query using criteria.</p>
  
  <p>SELECT * FROM A a_ INNER JOIN B b_ ON a_.column1=b_.column1 AND b_.column2 IN (X,Y) AND active='Y';</p>
  
  <p>I need the result as table A.</p>