iAnywhere.com - Subquery allowed only one select list item

SQL Anywhere® 10 - Error Messages > Database Error Messages > Alphabetic list of error messages

Subquery allowed only one select list item

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

Probable cause

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