SQLServer查询罗选后的结果集

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.Remarksfrom (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.IDwhere H.ColourWorkShop=1 and A.MO!='') I on I.MO=D.DocNoleft 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.IDwhere H.ColourWorkShop=0 and A.MO!='') J on J.MO=D.DocNoleft join (select * from SM_ShipLine where SrcDocNo!='' ) G on G.SrcDocNo=D.DocNoleft 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='') Aleft join (select B.a,B.b,B.c from B where XXXXX) B on A.a=B.b*/