A subquery of this kind cannot return more than one record. Revise the SELECT statement of the subquery to request only one record.