A subquery used in an SQL expression must specify a single
result column.
Explanation
A subquery used in an expression can not specify
multiple result columns. For example, the expression X > (select A,B
from T) is invalid because it specifies two result columns (A and
B).