select ROW_NUMBER()OVER(ORDER BY D.BusinessDate) AS '序号','接单日期'=D.BusinessDate,'合同号'=D.DocNo,'色号'=D.proName,'客户'=D.cusName,'流水号'=D.DocNo,'料品'=D.ItemInfo_ItemName,
'工序'=A.GX,'出缸时间'=A.ZYEndDate,
'染色水溶数量'=I.Qty,'染色质量状况'=I.ZLZK,'定型烘干时间'=J.Date,'定型烘干数量'=J.Qty,'定型质量状况'=J.ZLZK,
'发货时间'=G.ShipConfirmDate,'发货数量'=G.QtyPriceAmount,'备注'=A.Remarks
from (select S.ID,S.BusinessDate,S.DocNo,C.Name as cusName,P.Name as proName,L.ItemInfo_ItemName from SM_SOLine L
inner join SM_SO S on S.ID=L.SO
inner join CBO_Customer_Trl C on C.ID=S.OrderBy_Customer
inner join CBO_Project_Trl P on P.ID=L.Project
where S.Org=1001011070000620 and L.DocLineNo=10) D
left join
(select A.ID,A.Qty,A.ZLZK,A.MO,A.Remarks from Cust_ClourValuationManageLine A
inner join Cust_ClourValuationManage H on A.ClourValuationManage=H.ID
where H.ColourWorkShop=1 and A.MO!='') I on I.MO=D.DocNo
left join
(select A.ID,A.Date,A.Qty,A.ZLZK,A.MO,A.Remarks from Cust_ClourValuationManageLine A
inner join Cust_ClourValuationManage H on A.ClourValuationManage=H.ID
where H.ColourWorkShop=0 and A.MO!='') J on J.MO=D.DocNo
left join (select * from SM_ShipLine where SrcDocNo!='' ) G on G.SrcDocNo=D.DocNo
left join
(select * from Cust_ClourValuationManageLine where MO!='') A on A.MO=D.DocNo
/*
注:
select * from (select A.a,A.b from A where A.a='',A.b='') A
left join (select B.a,B.b,B.c from B where XXXXX) B on A.a=B.b
*/
SQLServer查询筛选后的结果集
最新推荐文章于 2022-03-17 10:58:59 发布