这段SQL怎么用 MPJLambdaWrapper 实现？

[qichhhhh]

SELECT a.*, v.sealSum
FROM A a
LEFT JOIN (
    SELECT aa.id AS aaId, COUNT(b.id) AS sealSum
    FROM A aa
    LEFT JOIN B b ON aa.id = b.business_id
    GROUP BY aa.id
) v ON a.id = v.aaId

好像 LEFT JOIN 方法中没有办法生成临时表？

[yulichang]

不支持