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