Unlike a scalarSubquery,
a tableSubquery is allowed only:
- As a tableExpression in
a FROM clause
- With EXISTS, IN, or quantified comparisons
When used as a
tableExpression
in a FROM clause, or with
EXISTS, it can return multiple columns.
When used with IN or quantified
comparisons, it must return a single column.