第1个回答 2011-02-17
SELECT
o1.order_id,
MAX(o1.subtotal) AS 订单总金额,
SUM(o2.cost) AS 订单明细合计
FROM
`order` o1 JOIN order_details o2 ON (o1.order_id = o2.order_id)
GROUP BY
o1.order_id
HAVING
MAX(o1.subtotal) <> SUM(o2.cost)
第2个回答 2011-02-17
select order_id from order as o left join order_details as d on o.order_id = d,order_id where o.subtotal = d.cost
第3个回答 2011-02-17
select *
from `order` r inner join
(select order_id ,sum(cost) as c from order_details ) as x
on r.order_id = x.order_id
where r.subtotal <> x.c
或
select * from 'order' r where r.subtotal <> (select sum(cost) from order_details d where d.order_id =r.order_id)本回答被提问者采纳