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)
各位大神這是為啥啊？？？
uj5u.com熱心網友回復：
t.problem_reason在表或視圖 DP_INVOICE t 中有沒有 PROBLEM_REASON 的欄位（注意大小寫，有沒有混合大小寫的情況）
uj5u.com熱心網友回復：
wzdp.DP_INVOICE表中沒有problem_reason欄位？仔細查看下呢。uj5u.com熱心網友回復：
DP_INVOICE 表中沒有problem_reason欄位轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/13115.html
標籤：開發