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

Question

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

标识列无效 急急啊

Answer 1

该回答引用ChatGPT

ORA-00905错误表示无效的标识符，即SQL语句中出现了不存在的列或表。

---

根据你提供的SQL语句，错误可能出现在以下位置：

(select datafield3 from pos_policy_form where policynum=t.policynum)

这里使用了t.policynum，但在主查询中t是pos_policy_form表的别名，因此该子查询无法正确地引用t.policynum列。

---

解决方法是将t.policynum列的别名添加到子查询中，例如：

(select datafield3 from pos_policy_form where policynum=t.policynum) as policynum

这样就可以正确地引用t.policynum列了。