在FROM子句中休眠DetachedCriteria

    orders: id
    items: id, orderId, total, flag

我想使用Hibernate条件(DetachedCriteria)进行以下查询:

    SELECT
        o.id,
        SUM(i1.total),
        SUM(i2.total)
    FROM
        orders o
            LEFT JOIN
            (
                SELECT
                    i.orderId as orderId,
                    SUM(i.total) as total
                FROM
                    items i
               WHERE
                    i.flag = 0
               GROUP BY
                    orderId
           ) AS i1
           ON i1.orderId = o.id
            LEFT JOIN
           (
               SELECT
                i.orderId as orderId,
                  SUM(i.total) as total
                FROM
                   items i
               WHERE
                   i.flag = 1
               GROUP BY
                    orderId
            ) AS i2
            ON i2.orderId = o.id
    GROUP BY
        o.id

DetachedCriteri 在中创建子查询的方法 WHERE FROM 条款如果这是不可能的,也许有一种方法可以把它写下来 SELECT 第条(内) SUM() ),因为此查询可以重写为这样的形式。

我确实需要使用CriteriaAPI,即使我必须将本机SQL传递给查询。