In this blog post, you’ll learn more about the Sybase Error Subquery allowed only one SELECT list item and the reason for receiving this error
Sybase SQL Error Message
Subquery allowed only one SELECT list item
Reason for this Error
You entered a subquery that has more than one column in the SELECT list. Change the SELECT list to have only one column.