Error 186

"Subquery cannot return more than one row"

Item Description

SQLCode

-186L

Constant

SUBQUERY_RESULT_NOT_UNIQUE

SQLState

21W01

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2117

Severity Code

16

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.

Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com