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

Question

我写以下查询作为源在我的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;

Answer 1

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