1       15:50:17  SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00,
K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00,
C.CKDH00,K.QRSJ00,
X.GZDJ00,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL) GWYPFL, 
SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE
 FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X
 WHERE C.CKDH00 ='1061352'
 AND  C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00
 AND  C.YPNM00=X.YPNM00 AND X.YFBMBH=45
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,D.Lbbh00,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL),
          C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000,
          C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00
,C.CKDH00,K.QRSJ00
ORDER BY D.DXSYBZ,X.GZDJ00,X.PDXH00,GWYPFL,D.JXBH00,D.YLBH00,D.YPBM00,D.Lbbh00

2       15:50:17  SQL Error: ORACLE - ORA-00979: 不是 GROUP BY 表达式

3       15:50:17  SQL Error: ORACLE - Unmapped SQL Error Code: 979
4       15:50:17  SQL Data In: ORACLE - Rows affected = 0
5       15:50:19  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

6       16:28:08  Log started for: SQL Navigator for Oracle