SELECT DW.JC SYGSMC,Y.YPMC,YL.YPMC YL,C.JC LCMC,P.JC PPMC,G.GGXHMC,J.JLDWMC,ISNULL(T.BCJY,0) SL, ROUND(ISNULL(T.BCJY,0)*(IsNull(T.GJHSXS,0))/1000,6) SLD, BM.BMMC,SYGS.JC SYGS FROM RJZ_BGKCJZB T,RBM_SYGSBMB DW,RBM_YPBMB Y,RBM_YPBMB YL,RBM_CSBMB C,RBM_PPBMB P,RBM_GGXHBMB G,RBM_JLDWBMB J, RJC_BMDYB BM,RBM_SYGSBMB SYGS WHERE T.JZXH IN ( Select Max(AA.JZXH) From RJZ_BGKCJZB AA WHERE SYGSBM IN ('0103110000','0103110002','0103110003','0103110004','0103110005','0103110006','0103110007','0103110008','0103110009','0103110010','0103110011','0103110012','0103110013','0103110014','0103110015','0103110016','0103110017','0103110018','0103110019','0103110020','0103110021','0103110001') And AA.RQ <= '2005-02-28' AND BM.BMMC = '01040004' And AA.YPBM = BM.YPBM AND ISNULL(AA.LCBM,'') = ISNULL(BM.LCBM,'') AND ISNULL(AA.PPBM, '') = ISNULL(BM.PPBM, '') AND ISNULL(AA.GGXHBM, '') = ISNULL(BM.GGXHBM, '') AND ISNULL(AA.JLDWBM,'') = ISNULL(BM.JLDWBM,'') GROUP BY AA.SYGSBM,AA.YPBM,AA.PPBM,AA.GGXHBM,AA.JLDWBM,AA.LCBM ) AND DW.SYGSBM = T.SYGSBM And SUBSTRING(DW.SYGSBM,1,7) = SYGS.SYGSBM AND Y.YPBM = T.YPBM AND YL.YPBM = SUBSTRING(T.YPBM,1,5) AND ISNULL(T.LCBM,'') *= C.LCBM AND ISNULL(T.PPBM,'') *= P.PPBM AND ISNULL(T.GGXHBM,'') *= G.GGXHBM AND ISNULL(T.JLDWBM,'') *= J.JLDWBM AND BM.BMMC = '01040004' And T.YPBM = BM.YPBM AND ISNULL(T.LCBM,'') = ISNULL(BM.LCBM,'') AND ISNULL(T.PPBM, '') = ISNULL(BM.PPBM, '') AND ISNULL(T.GGXHBM, '') = ISNULL(BM.GGXHBM, '') AND ISNULL(T.JLDWBM,'') = ISNULL(BM.JLDWBM,'') UNION ALL SELECT DW.JYZMC SYGSMC,Y.YPMC,YL.YPMC YL,C.JC LCMC,P.JC PPMC,G.GGXHMC,J.JLDWMC,ISNULL(T.BCJY,0) SL, ROUND(ISNULL(T.BCJY,0)*IsNull(T.GJHSXS,0)/1000,6) SLD, BM.BMMC,SYGS.JC SYGS FROM RJZ_JYZBGKCJZB T,RJC_JYZDA DW,RBM_YPBMB Y,RBM_YPBMB YL,RBM_CSBMB C,RBM_PPBMB P,RBM_GGXHBMB G,RBM_JLDWBMB J, RJC_BMDYB BM,RBM_SYGSBMB SYGS WHERE T.JZXH IN ( Select Max(AA.JZXH) From RJZ_JYZBGKCJZB AA WHERE XGSBM IN ('0103110000','0103110002','0103110003','0103110004','0103110005','0103110006','0103110007','0103110008','0103110009','0103110010','0103110011','0103110012','0103110013','0103110014','0103110015','0103110016','0103110017','0103110018','0103110019','0103110020','0103110021','0103110001') And AA.RQ <= '2005-02-28' AND BM.BMMC = '01040004' And AA.YPBM = BM.YPBM AND ISNULL(AA.LCBM,'') = ISNULL(BM.LCBM,'') AND ISNULL(AA.PPBM, '') = ISNULL(BM.PPBM, '') AND ISNULL(AA.GGXHBM, '') = ISNULL(BM.GGXHBM, '') AND ISNULL(AA.JLDWBM,'') = ISNULL(BM.JLDWBM,'') GROUP BY AA.JYZBM,AA.YPBM,AA.PPBM,AA.GGXHBM,AA.JLDWBM,AA.LCBM ) AND DW.JYZBM = T.JYZBM And SUBSTRING(DW.JYZBM,1,7) = SYGS.SYGSBM AND Y.YPBM = T.YPBM AND YL.YPBM = SUBSTRING(T.YPBM,1,5) AND ISNULL(T.LCBM,'') *= C.LCBM AND ISNULL(T.PPBM,'') *= P.PPBM AND ISNULL(T.GGXHBM,'') *= G.GGXHBM AND ISNULL(T.JLDWBM,'') *= J.JLDWBM AND BM.BMMC = '01040004' And T.YPBM = BM.YPBM AND ISNULL(T.LCBM,'') = ISNULL(BM.LCBM,'') AND ISNULL(T.PPBM, '') = ISNULL(BM.PPBM, '') AND ISNULL(T.GGXHBM, '') = ISNULL(BM.GGXHBM, '') AND ISNULL(T.JLDWBM,'') = ISNULL(BM.JLDWBM,'')