Select 产品代码,产品型号规格,颜色,sum(订单数量) As 订单数量,0 As 发货数量 from 销售订单明细 group by 产品代码,产品型号规格,颜色
改为
(select a.*,b.计量单位 from (Select 产品代码,产品型号规格,颜色,sum(订单数量) As 订单数量,0 As 发货数量 from 销售订单明细 group by 产品代码,产品型号规格,颜色) as a left join 销售订单明细 as b on a.产品代码=b.产品代码 and a.产品型号规格=b.产品型号规格 and a.颜色=b.颜色)