--查询物品id 对应8库存管理中的实际数量(在库数量)
SELECT product_guid, SUM(quantity) as stocknum
FROM bas_stock
GROUP BY product_guid
--(查询出储位个数,相同的忽略)
SELECT product_guid, count( DISTINCT cargo_space_id) as stocknum
FROM bas_stock
GROUP BY product_guid
--查询物品id 对应8库存管理中的实际数量(在库数量)
SELECT product_guid, SUM(quantity) as stocknum
FROM bas_stock
GROUP BY product_guid
--(查询出储位个数,相同的忽略)
SELECT product_guid, count( DISTINCT cargo_space_id) as stocknum
FROM bas_stock
GROUP BY product_guid