Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Subquery allowed only one select list item Next Page

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.