Subquery returned more than one record (Error 1860)

Subqueries linked with the six normal operators <>, =, <=, >=, < or >, excluding ALL or ANY, can produce only a one-row result.