Previous Topic: -70 - ODER BY COLUMN aaaa IS NOT IN SELECT LIST OR IS A DUPLICATENext Topic: -72 - CANNOT NEST COLUMN FUNCTIONS

SQL Codes › SQL Return Codes -1 through -999 › -71 - SELECTING MORE THAN ONE ITEM IN A SUBQUERY

-71 - SELECTING MORE THAN ONE ITEM IN A SUBQUERY

Reason:

A subquery specifies more than one item in its SELECT list.

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

Action:

Restructure the query so that no more than a single item is specified in the SELECT list.