SQL语句如下:
select TE.FSNAME DEPTNAME,TB.FSWEITDW CGR,COUNT(TB.FSCASEID) XMNUM,SUM(NVL(TB.FIWEITJERMB,0)) XMYS,SUM(NVL(TB.FIZHONGBJE,0)) XMZBJE,SUM(NVL(TB.FIZHONGBIAOFUWUFEI,0)) XMZBFUWF1,SUM(NVL(TB.FLZHONGZBFWF,0)) XMZBFUWF2
from OMWB_LOGIN1.TZBBASEINFO TB
INNER JOIN OMWB_LOGIN1.EXIDEPTINFO TE
ON TB.FSXIANGMGS='D'||TE.FSDEPTID
WHERE TB.FSZHUXMBH IS NULL
GROUP BY TB.FSXIANGMGS,TE.FSNAME,TB.FSWEITDW
ORDER BY TE.FSNAME;
select TE.FSNAME DEPTNAME,TB.FSWEITDW CGR,COUNT(TB.FSCASEID) XMNUM,SUM(NVL(TB.FIWEITJERMB,0)) XMYS,SUM(NVL(TB.FIZHONGBJE,0)) XMZBJE,SUM(NVL(TB.FIZHONGBIAOFUWUFEI,0)) XMZBFUWF1,SUM(NVL(TB.FLZHONGZBFWF,0)) XMZBFUWF2
from OMWB_LOGIN1.TZBBASEINFO TB
INNER JOIN OMWB_LOGIN1.EXIDEPTINFO TE
ON TB.FSXIANGMGS='D'||TE.FSDEPTID
WHERE TB.FSZHUXMBH IS NULL
GROUP BY TB.FSXIANGMGS,TE.FSNAME,TB.FSWEITDW
ORDER BY TE.FSNAME;
http://img5.ph.126.net/siiQ3-9XOqTmte0x8HXnqw==/2601110259800999735.jpg