Error 186

Message text

Subquery cannot return more than one result

Item

Value

SQLCode

-186

Constant

SQLE_SUBQUERY_RESULT_NOT_UNIQUE

SQLState

21W01

ODBC State

42000

Probable cause

The result of a subquery contains more than one row. If the subquery is in the WHERE clause, you might be able to use IN.