CA OLQ OQ Messages › OQ143018

OQ143018

ORDER BY columns must be referenced by a column number.

Reason:

When you specify UNION or UNION ALL, the ORDER BY columns must be referenced by column number. For example:

SELECT EMP-ID, EMP-LAST-NAME FROM EMPLOYEE
 UNION
SELECT EMP-ID, EMP-LAST-NAME FROM EMPLOYEE
 ORDER BY EMP-LAST-NAME

Should be stated as:

SELECT EMP-ID, EMP-LAST-NAME FROM EMPLOYEE
 UNION
SELECT EMP-ID, EMP-LAST-NAME FROM EMPLOYEE
 ORDER BY 2

Module:

OLQSSCAN

Severity:

0