At most one record can be returned by this subquery. (Error 3354)

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