Hitachi

Hitachi Advanced Database Messages


KFAA30208-E

The column "aa....aa" specified in the ORDER BY clause is not specified as a column in the SELECT clause of the outermost 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 was specified for the outermost query specification.

aa....aa:

Column name

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.