我有两张桌子
table_orders - order_id, customer_id;
table_order_details - order_id, product_sell_price, quantity;
我想得到每个订单的订单价值(金额总和)。我正在尝试以下查询:
mysql> select O.order_id, sum(OD.product_sell_price * OD.quantity) from table_order_details as OD INNER JOIN table_orders as O where O.order_id = TOD.order_id;
但它给出的是总金额,即所有订单的金额。
如何获取每个订单的订单值?
有人能帮我吗?
最佳答案
在末尾添加分组依据
SELECT O.order_id, SUM(OD.product_sell_price * OD.quantity)
FROM table_order_details as OD
INNER JOIN table_orders as O
ON O.order_id = OD.order_id
GROUP BY O.order_id
关于mysql - 函数SUM无法在MYSQL中按预期工作,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/34470746/