ora-00904无效标识符错误在哪里?

1wnzp6jl  于 2021-07-26  发布在  Java
关注(0)|答案(1)|浏览(477)

我在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;
p8h8hvxi

p8h8hvxi1#

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

相关问题