2 xiyan1011 xiyan1011 于 2013.10.11 16:51 提问

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
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!