标识符无效

[情绪大师]

SELECT t.*,u.user_name, de.dep_name xmdw, re.s_name gys,rt.RETURN_USER,rt.RETURN_REASON,rt.RETURN_TIME,pp.value
from wzdp.GUARD_STATE1 pp, wzdp.DP_INVOICE t,wzdp.sys_user u,SYS_DEPARTMENT de,wzapp.app_regact re, (select k.RETURN_REASON,k.RETURN_time,k.zebeln,sr.user_name RETURN_USER from wzdp.dp_invoice_return k,(select MAX(RETURN_TIME) RETURN_TIME,zebeln from wzdp.dp_invoice_return GROUP BY ZEBELN) o,WZDP.SYS_USER SR
where pp.id=t.problem_reason and o.zebeln=k.ZEBELN and o.RETURN_TIME=k.RETURN_TIME AND SR.USER_ID=k.RETURN_USER) rt WHERE t.RECEIVE_USER=u.user_id(+) and de.dep_id=t.BUKRS and re.s_erp=t.SUPPLIER and rt.zebeln(+)=t.zebeln and t.zebeln='4100408462' order by t.zntdh,to_number(t.znum)


各位大神这是为啥啊？？？

[山林73]

t.problem_reason 在表或视图 DP_INVOICE t 中有没有 PROBLEM_REASON 的字段（注意大小写，有没有混合大小写的情况）

[lhdz_bj]

wzdp.DP_INVOICE表中没有problem_reason字段？仔细查看下呢。

[Rotel-刘志东]

DP_INVOICE 表中没有problem_reason字段