- 论坛徽章:
- 0
|
我写了一段SQL语句,语法没有错,可以运行,但是其中某几天的数据怎么也查不出来,如果多加一个条件则可以查询出结果
产生的错误号为:
SQL0901N SQL 语句因为不严重的系统错误而失败。可以处理后续 SQL 语句。
(原因为 "bad outer compare"。) SQLSTATE=58004
SQL语句为:
select '' as kcgg, a.CGGYDM ||' - '|| e.KCBSMC, b.KCPZGG,a.KCWPDM,b.KCWPXH,b.KCWPMC, sum(case when a.kcrkzt='R' THEN 1 ELSE 0 END) as KCRKSL, sum((CASE WHEN A.KCRKZT='C' THEN 1 ELSE 0 END)) as KCCKSL, sum((case when a.kcrkzt='R' THEN 1 ELSE 0 END)+(CASE WHEN A.KCRKZT='C' THEN (-1) ELSE 0 END) ) as KCCZSL, max(a.KCBCDM ||' - '|| d.KCBCSM), max(a.KCCZR1) from db2admin.KCT97 a, db2admin.KCM02 b, db2admin.CGM03 c, db2admin.KCM40 d, db2admin.KCM54 e where a.KCWPDM = b.KCWPDM and a.CGGYDM = e.CGGYDM and SUBSTR(a.XSVINM, 11, 1) = e.KCBSDM and a.KCBCDM = d.KCBCDM and a.CGGYDM = c.CGGYDM and (KCCZDM='J' or (KCCZDM='B' and KCRKZT='C')) and KCCZR1>;=20030117 and KCCZR1<=20030117 group by a.CGGYDM ||' - '|| e.KCBSMC, b.KCPZGG,a.KCWPDM,b.KCWPXH,b.KCWPMC order by a.CGGYDM ||' - '|| e.KCBSMC, b.KCPZGG |
|