您可以使用此DetachedCriteria
DetachedCriteria subCriteria= DetachedCriteria.forClass(Departament.class); subCriteria.add(Property.forName("departmentname ").eq("HR")); subCriteria.add(Property.forName("location ").eq("xyz")); subCriteria.setProjection(Projections.property("company_id "));DetachedCriteria criteria = DetachedCriteria.forClass(Company.class); criteria.add(Property.forName("id").in(subCriteria));


