尝试类似以下示例的操作来创建子查询:
CriteriaQuery<Object[]> cq = cb.createQuery(Object[].class);Root tableA = cq.from(TableA.class);Subquery<String> sq = cq.subquery(TableB.class);Root tableB = cq.from(TableB.class);sq.select(tableB.get("d"));sq.where(cb.equal(tableB.get("id"), 3));cq.multiselect( cb.get("a"), cb.get("b"), cb.get("c"));cq.where(cb.equal(tableA.get("a"), sq));List<Object[]> = em.createQuery(cq).getResultList();请注意,由于附近缺少IDE,因此该代码尚未经过测试。



