Previous Topic: -71 - SELECTING MORE THAN ONE ITEM IN A SUBQUERYNext Topic: -73 - SELECTED COLUMNS MUST BE IN THE GROUP BY CLAUSE

SQL Codes › SQL Return Codes -1 through -999 › -72 - CANNOT NEST COLUMN FUNCTIONS

-72 - CANNOT NEST COLUMN FUNCTIONS

Reason:

A statement has been detected which contains nested levels of column functions (such as SUM or AVG).

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

Action:

Restructure the query in question so that column functions do not nest.