休眠条件与2个条件子句中1个查询

Question

我如何acheive以下SQL查询使用休眠条件查询：

select * from Table1 where (A,B) in (select A,B from Table2) 

Answer 1

假设我们具有下面的代码表2.关于表1标准和标准独立工作完美：

Criteria criteria = new Criteria(Table1.class); 

DetachedCriteria dc = DetachedCriteria.forClass(Table2.class); 
ProjectionList projList = Projections.projectionList(); 
projList.add(Projections.property("column1")); 
projList.add(Projections.property("column2")); 
dc.setProjection(Projections.distinct(projList)); 

criteria.add(Subqueries.propertiesIn(new String[]{"column1","column2"}, dc));