<pre id=\\\"best-answer-content\\\">select *
from `order`r inner join
(selectorder_id ,sum(cost) as c from order_details ) as x
on r.order_id = x.order_id
where r.subtotalx.c
或
select * from \\\'order\\\' r where r.subtotal(select sum(cost) from order_details d where d.order_id =r.order_id)
<pre class=\\\"answer-content\\\">SELECT
o1.order_id,
MAX(o1.subtotal)AS订单总金额,
SUM(o2.cost) AS订单明细合计
FROM
`order` o1 JOIN order_detailso2ON(o1.order_id = o2.order_id)
GROUP BY
o1.order_id
HAVING
MAX(o1.subtotal) SUM(o2.cost)