KFAA30208-E
The column "aa....aa" specified in the ORDER BY clause is not specified as a column in the SELECT clause of the query. (M+J+O)
A column that is not specified in the selection expression cannot be specified in the ORDER BY clause due to one of the following reasons: <SQLSTATE:42743>
-
A SELECT DISTINCT was specified.
-
A set operator for the query specification, which is the first set operation operand in the set operation, is specified.
- aa....aa:
-
Column name
- S:
-
Ignores this SQL statement.
- Action:
-
Correct the SQL statement so that it satisfies one of the following conditions.
-
The same value expression as the value expression specified in the ORDER BY clause is specified in the selection expression of the query specification that specifies SELECT DISTINCT.
-
The same value expression as the value expression specified in the ORDER BY clause is specified in the selection expression of the query specification, which is the first set operation operand of the set operation.
-