cmd.CommandText = "Selec t *,订单数量 - 发货数量 As 欠货数量 from (Selec t 产品代码,产品型号规格,颜色,sum(订单数量) As 订单数量,0 As 发货数量 from 销售订单明细 group by 产品代码,产品型号规格,颜色 union all Selec t 产品代码,产品型号规格,颜色,0 As 订单数量,sum(出仓数量) As 发货数量 from 产品明细 group by 产品代码,产品型号规格,颜色) As a where 订单数量 - 发货数量 <> 0"
加好友 
发短信
Post By：2020/7/30 20:13:00 [只看该作者]
此主题相关图片如下：snap1.jpg