select case when A.CGRP_NO is null then c.cifn else A.CGRP_NO end no,
case when ce.cgrp_name is null then
case when A.CHN_NAME is null OR rtrim(A.CHN_NAME)='' then A.CUST_NAME else A.CHN_NAME end
else rtrim(ce.cgrp_name) end CGRP_NAME,
sum( c.INT_INCOME_MOP+c.CHRG_MOP+c.INT_EXPENSE_MOP) mop,
sum( c.INT_INCOME_HKD+c.CHRG_HKD+c.INT_EXPENSE_HKD) hkd
from CAM_LOAN_IE as c
left join curl A on c.CIFN =A.cifn
left join CGET ce on ce.CGRP_NO=A.CGRP_NO
where 1=1 AND c.AC_DATE>='200805' AND c.AC_DATE<='200805'
group by case when A.CGRP_NO is null then c.cifn else A.CGRP_NO end,
case when ce.cgrp_name is null then
case when A.CHN_NAME is null OR rtrim(A.CHN_NAME)='' then A.CUST_NAME else A.CHN_NAME end
else rtrim(ce.cgrp_name) end
order by hkd DESC, no
fetch first 800 rows only
增加输出一列 A.CUBK 运行报db2 sql error:sqlcode:-119 sqlstate:42803 ,CUBK。。。请教高手如何解决?
收起