求助

rocker of estua

我写了一段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