Subquery allowed only one select list item

Item Value
SQLCODE -151
Constant SQLE_SUBQUERY_SELECT_LIST
SQLSTATE 53023
Sybase error code 102
ODBC 2 State 37000
ODBC 3 State 42000

Probable cause 

You entered a subquery which has more than one column in the select list. Change the select list to have only one column.