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.
Created June 15, 2009. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com