In this blog post, you’ll learn more about the Sybase Error Subquery cannot return more than one row and the reason for receiving this error
Sybase SQL Error Message
Subquery cannot return more than one row
Reason for this Error
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.