logo  
Google
 

DB2 SQL-Error: -208

SQLState: 42707

Short Description: THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN IS NOT PART OF THE RESULT TABLE C SQL SELECT

The statement is invalid because a column ('name') specified in the ORDER BY list does not appear in the result table (that is, it is not specified in the SELECT-list). Only columns in the result table can be used to order that result when the fullselect of the select-statement is not a subselect. System action: The statement cannot be executed. Programmer response: Correct the syntax of the statement, either by adding the specified column to the result table, or deleting it from the ORDER BY clause. Refer to Chapter 4 of DB2 SQL Reference for information about restrictions on the use of the ORDER BY clause

 <-  BACK TO INDEX