如何在休眠条件中编写多个子查询

Question

我正在尝试用休眠条件编写oracle子查询，但无法做到。谁能帮助我实现这一目标。下面是我的预言机查询。

SELECT a.id,
  b.address
FROM tableA a
INNER JOIN TABLE b
ON a.id       = b.id
WHERE mainId IN
  (SELECT bp.ptyID
  FROM bpTable bp,
    busHeaderbh bh
  WHERE bh.aid      = bp.aid
  AND bh.parentBID IN
    (SELECT bp.ptyID
    FROM bpTable bp,
      busHeaderbh bh
    WHERE bh.aid     = bp.aid
    AND bh.parentBID = 123
    UNION
    SELECT 123 FROM dual
    )
  UNION
  SELECT 123 FROM dual
  )
AND
GROUP BY a.id,
  b.credttm
ORDER BY a.id DESC;

提前谢谢。

Answer 1

我已经为一对多关系表写了一个示例你可以从中获得参考

Criteria person = session.getCurrentSession().createCriteria(Person.class).createAlias("personId", "personId");
person.add(Restrictions.disjunction().add(Restrictions.ilike("PersonFirstname",Search,MatchMode.ANYWHERE))
.add(Restrictions.ilike("personId.prop1",Search,MatchMode.ANYWHERE))
.add(Restrictions.ilike("personId.col1",Search,MatchMode.ANYWHERE))
.addOrder(Property.forName("colName").desc()
.addOrder(Property.forName("colName").asc());