我在adf中编写以下查询作为源代码。我得到以下错误:
错误[42s22][microsoft][odbc oracle wire protocol driver][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;
1条答案
按热度按时间p8h8hvxi1#
此错误消息通常表示您引用的表列不存在。我将检查您使用的列名是否都存在于基础表中。