Subquery cannot return more than one row

Item Value
SQLCODE -186
Constant SQLE_SUBQUERY_RESULT_NOT_UNIQUE
SQLSTATE 21W01
Sybase error code 512
ODBC 2 State 37000
ODBC 3 State 42000

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.