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 ...