Previous Topic: -315 - ONLY THE PLAN CREATOR MAY MODIFY PLAN SECURITY OPTIONS DURING REBINDNext Topic: -317 - CURSOR cursor-name ERROR: MULTIPLE stmt-type STATEMENTS ATTEMPTED

SQL Codes › SQL Return Codes -1 through -999 › -316 - %s.%s OUTSIDE SCOPE OF JOINED TABLE

-316 - %s.%s OUTSIDE SCOPE OF JOINED TABLE

Explanation

Indicates the rejection of a column reference to a table that is outside (a higher level than) the current join. In the text of the message above, %s.%s indicates the table.columnname of the invalid reference. For example, for a case in which the message text was as follows,

TABLE1.COLUMN OUTSIDE SCOPE OF JOINED TABLE

Consider the following related SELECT statement in which the first ON is for the nested join for TABLE2 and TABLE3 and cannot reference the outer (higher level) join with TABLE1.

SELECT *
  FROM TABLE1 LEFT JOIN (TABLE2 LEFT JOIN TABLE3
    ON TABLE1.COLUMN = TABLE2.COLUMN)
    ON TABLE1.COLUMN = TABLE3.COLUMN;

The SQLSTATE that equates to this SQL return code is 42S12.

User Response

Correct the column reference as needed.