1 09:16:38 SQL Execute: ORACLE - select B.ZYID00,B.BRID00,B.XMBH00,B.XMMC00,B.XMGG00,B.XMDW00,sum(B.XMSL00) XMSL00,sum(B.HJJE00) HJJE00,XMBZ00, SHJG00, ZFBL00,Sum(nvl(TCJE00,0)) AS TCJE00 from vw_zy_ybfymx B where ZYID00= group by B.ZYID00,B.BRID00,B.XMBH00,B.XMMC00,B.XMGG00,B.XMDW00,B.XMDJ00,XMBZ00,SHJG00,ZFBL00 ORDER BY XMBZ00 2 09:16:38 SQL Data In: ORACLE - Rows affected = 0