sdwe9091 发表于 2013-10-9 17:13
请问为啥加了这个substr就会出现这个错误?实在搞不明白了。。
如果不按照bell的SQL,只是在你的SQL基础上解决问题的话。。这样写:
select (select so.org_name from sta_org so where so.org_no = stat.org_no) as org,
sum(stat.agmt_num) as ctrt_num_e,
sum(stat.loan_bal) as loan_bal_e,
stat.proj_id
from (select sta.proj_id,sta.cycle_term,substr(sta.org_no,1,2) org_no,sta.agmt_num,sta.loan_bal from sta_proj_srep_stat sta group by substr(sta.org_no,1,2) ) stat
where 1 = 1
and stat.proj_id = '70'
and stat.cycle_term = '4'
group by stat.org_no, stat.proj_id;
|