主页 / 问题 / 667342
Accepted
cruim
Asked:2020-05-18 00:27:45 +0800 CST2020-05-18 00:27:45 +0800 CST

具有相同字段值的行数

  • 772

有一个请求

SELECT
    salesorderid,
    integration_betapost.goods_to_products.shipping_order_row_good_id,
    vtiger_inventoryproductrel.quantity
FROM
    vtiger_salesorder
INNER JOIN vtiger_inventoryproductrel ON vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id
INNER JOIN vtiger_products ON vtiger_inventoryproductrel.productid = vtiger_products.productid
INNER JOIN integration_betapost.goods_to_products ON vtiger_products.productid = integration_betapost.goods_to_products.productid
WHERE
    sostatus = 'Отправлять'

其中显示表单结果的结果 问题是，如何计算具有相同的行的总和以及具有相同的 salesorderid行的总和？salesorderidshipping_order_row_good_id

mysql

1 个回答

  1. Best Answer
    SELECT
    salesorderid,
    integration_betapost.goods_to_products.shipping_order_row_good_id,
    sum(Quantity)
FROM
    vtiger_salesorder
INNER JOIN vtiger_inventoryproductrel ON vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id
INNER JOIN vtiger_products ON vtiger_inventoryproductrel.productid = vtiger_products.productid
INNER JOIN integration_betapost.goods_to_products ON vtiger_products.productid = integration_betapost.goods_to_products.productid
WHERE
    sostatus = 'Отправлять'
GROUP BY
    salesorderid
    ,integration_betapost.goods_to_products.shipping_order_row_good_id
order by salesorderid desc
    • 0

相关问题