-208   THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN column-name IS NOT PART OF THE RESULT TABLE

Explanation

The statement is invalid because a column (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 processed.

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.

SQLSTATE

42707