主题：调用后台统计数据

不参与分组就只能这样的用法。

把你试的代码发上来

cmd.CommandText = "S elect *, 订单数量 - 发货数量 As 欠货数量 from (s elect 产品代码,产品型号规格,颜色,单位,sum(订单数量) As 订单数量,sum(发货数量) As 发货数量 from (S elect 产品代码,产品型号规格,颜色,单位,sum(订单数量) As 订单数量,0 As 发货数量 from 销售订单明细 group by 产品代码,产品型号规格,颜色 union all S elect 产品代码,产品型号规格,颜色,0 As 订单数量,sum(发货数量) As 发货数量 from 销售发货明细 group by 产品代码,产品型号规格,颜色) As a group by 产品代码,产品型号规格,颜色) as b where 订单数量 - 发货数量 <> 0 " 

红色sql替换为21楼的用法，然后把21楼销售订单明细改为销售发货明细，替换下面蓝色的sql

cmd.CommandText = "S elect *, 订单数量 - 发货数量 As 欠货数量 from ((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.颜色 ) union all (select a.*,b.计量单位 from (Select 产品代码,产品型号规格,颜色,. As 订单数量,sum(发货数量) from 销售发货明细 group by 产品代码,产品型号规格,颜色) as a left join 销售订单明细 as b on a.产品代码=b.产品代码 and a.产品型号规格=b.产品型号规格 and a.颜色=b.颜色 ))  as b where 订单数量 - 发货数量 <> 0 " 

cmd.CommandText = "S elect *, 订单数量 - 发货数量 As 欠货数量 from ((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.颜色 ) union all (select c.*,d.计量单位 from (Select 产品代码,产品型号规格,颜色,0 As 订单数量,sum(发货数量) from 销售发货明细 group by 产品代码,产品型号规格,颜色) as c left join 销售订单明细 as d on c.产品代码=d.产品代码 and c.产品型号规格=d.产品型号规格 and c.颜色=d.颜色 ))  as e where 订单数量 - 发货数量 <> 0 "