SELECT c.Goodsxl as 系列名, c.Gyno as 物供号, c.ZDNO as 制单号, B.Orderno as 订单号, B.MakeGro as 班组, B.Ftyno AS 款号,c.ClientStyle as 客款号,b.QCType as 不合格原因, Sum(Isnull(b.num,0)) as 返工件数
F ROM Qc_Main A LEFT JOIN QC_ReturnMake B ON A.ID=B.UpID left join pq_main C ON B.Orderno =C.ORDERNO
WHERE C.ZDNO='18011514' and Isnull(b.num,0) >0
GROUP BY c.Goodsxl,c.Gyno,c.ZDNO,B.Orderno,B.MakeGro,B.Ftyno,c.ClientStyle,B.QCTYPE
加好友 
发短信
Post By：2018/6/22 15:25:00 [只看该作者]
此主题相关图片如下：未命名.png