use 查询计划4
go
select a.订单号,a.UPC,a.英文名称,a.中文名称,a.单位,a.订单数量,sum(b.入库数量) as N'入库数量',sum(c.装箱数量) as N'装箱数量',a.办公室 from 订单记录表 as a left outer join 订单入库表 as b on a.订单号=b.订单号 and a.upc=b.upc select a.订单号,a.UPC,a.英文名称,a.
go
select a.订单号,a.UPC,a.英文名称,a.中文名称,a.单位,a.订单数量,sum(b.入库数量) as N'入库数量',sum(c.装箱数量) as N'装箱数量',a.办公室 from 订单记录表 as a left outer join 订单入库表 as b on a.订单号=b.订单号 and a.upc=b.upc select a.订单号,a.UPC,a.英文名称,a.
