SELECT nvl(sum(decode(MANNER.paymanner,'0',feesum,0))/100,0.0) ,
nvl(sum(decode(MANNER.paymanner,'2',feesum,0))/100,0.0) ,
nvl(sum(decode(MANNER.paymanner,'1',feesum,0))/100,0.0),
nvl(sum(decode(MANNER.paymanner,'1',feesum,'0',feesum,'2',feesum,0))/100,0.0)
FROM busi.t_cs_paymanner_0611_R MANNER 在proc中为何提示 "MANNER"."PAYMANNER": invalid identifier ORA-06512: at line 1 错误呢?
nvl(sum(decode(MANNER.paymanner,'2',feesum,0))/100,0.0) ,
nvl(sum(decode(MANNER.paymanner,'1',feesum,0))/100,0.0),
nvl(sum(decode(MANNER.paymanner,'1',feesum,'0',feesum,'2',feesum,0))/100,0.0)
FROM busi.t_cs_paymanner_0611_R MANNER 在proc中为何提示 "MANNER"."PAYMANNER": invalid identifier ORA-06512: at line 1 错误呢?
二楼,只对一个表查询也可以用别名的。
原先一直 没有对一个表进行别名 呵呵feesum把这个列也加上别名