1       22:39:22  SQL Execute: ORACLE - select ZY0000,XYLSJE,CYLSJE,ZYLSJE,YXLSJE,XYGJJE,CYGJJE,ZYGJJE,YXGJJE,HJGJJE,HJLSJE,HJLSJE-HJGJJE HJCJJE,SL0000    from     (select DECODE(NVL(INSTR(A.ZY0000,','),0),0,A.ZY0000,SUBSTR(A.ZY0000,1,INSTR(A.ZY0000,',')-1)) ZY0000,       SUM(DECODE(A.LBBH00,'0',SLJE00,0)) AS XYLSJE,    SUM(DECODE(A.LBBH00,'1',A.SLJE00,0)) AS CYLSJE,        SUM(DECODE(A.LBBH00,'2',SLJE00,0)) AS ZYLSJE,   SUM(DECODE(A.LBBH00,'3',A.SLJE00,0)) AS YXLSJE,       SUM(DECODE(A.LBBH00,'0',ROUND(A.SLSL00*A.GJDJ00,2),0)) AS XYGJJE,               SUM(DECODE(A.LBBH00,'1',ROUND(A.SLSL00*A.GJDJ00,2),0)) AS CYGJJE,        SUM(DECODE(A.LBBH00,'2',ROUND(A.SLSL00*A.GJDJ00,2),0)) AS ZYGJJE,                   SUM(DECODE(A.LBBH00,'3',ROUND(A.SLSL00*A.GJDJ00,2),0))  AS YXGJJE,     SUM(ROUND(A.SLSL00*A.GJDJ00,2)) AS HJGJJE, SUM(A.SLJE00) AS HJLSJE,    COUNT (DISTINCT(A.RKDH00)) AS SL0000                       from VW_YK_RKJZCX A,BM_BMBM00 B,XT_YYXX00  C  where                         A.RCLXBH in('01','02','10')    and SHRQ00>='20121201' AND SHRQ00<='20121216' and sfjz00='Y'                           and (C.YYID00='0'  OR  '0'='0')       and C.YYID00=B.YYID00 and (B.BMBH00='0' OR '0'='0')                          and B.BMXZ00='6' and        B.BMBH00=A.YKBMBH        group by  DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1))         order by ZY0000)        

2       22:39:22  SQL Error: ORACLE - ORA-00904: "A"."RKDH00": ±êʶ·ûÎÞЧ

3       22:39:22  SQL Data In: ORACLE - Rows affected = 0