A subselect used on the right-hand side of an = must probably return one row (one column, even). A subselect used on the right-hand side of an IN can probably return multiple rows (though presumably ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results