ANR2954E
An SQL subquery used in a scalar expression must yield a table that contains at most one row.

Explanation

This error results when a subquery used in a scalar expression returns multiple rows, thereby making it ambiguous as to which value should be returned.

System action

The SQL query is terminated.

User response

Respecify the subquery (for example, using the WHERE clause) so that the subquery returns at most one row.