I used the above query, but I get an error saying that the subquery returned more than one record.

Subquery returned more than 1 value. This is not permitted when...