Previous Topic: -69 - TOO MANY SET CLAUSES IN UPDATE COMMANDNext Topic: -71 - SELECTING MORE THAN ONE ITEM IN A SUBQUERY


-70 - ODER BY COLUMN aaaa IS NOT IN SELECT LIST OR IS A DUPLICATE

Reason:

No SELECT has been processed for a column which is the object of an ORDER BY clause. Also, column may have been specified multiple times in the ORDER BY list.

The SQLSTATE that equates to this SQL return code is 42707.

Action:

Correct the statement(s) so that the column to be ORDERed BY is selected and specified only once in the ORDER BY list.