尝试以下写法,关注楼主改进方案!---第一字段 (select decode(Scope,'2','大型企业','3','中型企业','4','小型企业','5','微型企业','') from customer_info ci where ei.customerid=ci.customerid and ci.customertype<>'0107'), --第二字段 (SELECT nvl(COGNRESULT, nvl(COGNRESULT3,COGNRESULT4)) FROM EVALUATE_RECORD ER WHERE ER.OBJECTTYPE = 'Customer' AND ER.EVALUATEPERIOD = '01' AND ER.EFFFLAG = '1' and ER.INVALIDATEDATE > to_char(sysdate,'yyyy/mm/dd') and ER.Objectno = ei.customerid and rownum = 1), ---第三字段 (select decode(max(classifyresult),'A1','正常类1','A2','正常类2','B1', '关注类1','B2','关注类2','B3','关注类3','C1','次级类1','C2','次级类2', 'D','可疑','E','损失','') from cl_info cl where classifyresult is not null and cl.customerid=ei.customerid
(select decode(Scope,'2','大型企业','3','中型企业','4','小型企业','5','微型企业','')
from customer_info ci where ei.customerid=ci.customerid and ci.customertype<>'0107'),
--第二字段
(SELECT nvl(COGNRESULT, nvl(COGNRESULT3,COGNRESULT4))
FROM EVALUATE_RECORD ER
WHERE ER.OBJECTTYPE = 'Customer'
AND ER.EVALUATEPERIOD = '01'
AND ER.EFFFLAG = '1'
and ER.INVALIDATEDATE > to_char(sysdate,'yyyy/mm/dd')
and ER.Objectno = ei.customerid and rownum = 1),
---第三字段
(select decode(max(classifyresult),'A1','正常类1','A2','正常类2','B1',
'关注类1','B2','关注类2','B3','关注类3','C1','次级类1','C2','次级类2',
'D','可疑','E','损失','') from
cl_info cl where
classifyresult is not null
and cl.customerid=ei.customerid