Subquery cannot return more than one row

Error 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.