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