ORA-00905:"T"."POLICYNUM":invalid identifier 急急啊

select t.policynum,
(select wmsys.wm_concat(c.countrycnname || '|' || c.countryenname) from webpos_country c

where c.countrycode in (
select 'aa' datafield3 from (select (select datafield3 from pos_policy_form where policynum=t.policynum) from dual)
)),
'Form ' || to_char(t.startdate, 'yyyy-mm-dd') || ' To ' ||to_char(t.enddate, 'yyyy-mm-dd'),to_char(t.startdate, 'yyyy-mm-dd'),t.summoney,t.policynum
from pos_policy_form t
where t.poscode = 'WP666666'
and t.sellformtype = 'UN075'
and t.operatorcode = '555555'
and t.batchnum = '86241300118960'
order by t.policynum

标识列无效 急急啊

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!