mysql求sql语句 查询订单明细金额累加与订单总金额不等的订单

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)

sum(price),

sum(total * cost),

DATE_FORMAT(

FROM_UNIXTIME(time, '%Y-%m-%d') AS DATA

FROM

table_order t1,

table_orderlist t2

WHERE

t1.id = t2.order_id

GROUP BY

DATE_FORMAT(

FROM_UNIXTIME(time, '%Y-%m-%d')