ORA-00904无效标识符.错误在哪里

Question

我正在ADF中编写以下查询作为源。我得到以下错误：

错误[42S22][Microsoft][ODBC Oracle有线协议驱动程序][Oracle]ORA-00904:：无效标识符

需要找出错误在哪里？

SELECT
SYSDATE AS "date_stamp",
rep.*
FROM
(
SELECT
s.subdivision,
s.activity_grp
FROM
ORC.z1subdiv  s
LEFT JOIN ORC.z1tmu t 
ON t.tmu = s.tmu
WHERE       
s.activity_grp LIKE 'Z%' AND
t.tmu_group IN ('ABC','PQR')
) sub
JOIN TABLE
(
lawson_crystal.xREPORTwrapper.main
( 
p_company_gl      => 'ALL',
p_activity_group =>  sub.activity_grp,
p_tmu        => 'ALL',
p_division   => 'ALL',
p_subdivision => sub.subdivision, 
p_project    => 'ALL',
p_exclude_statuses => 'N/A'
)
) rep ON 1 = 1;

Answer 1

此错误消息通常表示您引用的表列不存在。我会检查您正在使用的列名是否都存在于基础表中。