Collection Contents Index Subquery allowed only one select list item Next PDF

SQL Anywhere® 10 - Error Messages  > Database Error Messages  > Alphabetic list of error messages

Subquery cannot return more than one row


Item

Value

Constant

SQLE_SUBQUERY_RESULT_NOT_UNIQUE

ODBC 2 State

37000

ODBC 3 State

42000

Severity

16

SQLCODE

-186

SQLSTATE

21W01

Sybase error code

512

Probable cause

You used a subquery that returns more than one row, in a context where only a single row can be used. If the subquery is in the WHERE clause, you might be able to use the IN keyword.


Collection Contents Index Subquery allowed only one select list item Next PDF