Scalar Subqueries
A scalar subquery is a subquery that returns a single value. It can be used anywhere a single column value or literal is valid.
A subquery can reside within a WHERE clause, a FROM clause, or a SELECT clause.
Example
SELECT *
FROM table1
WHERE column1 = (SELECT column1 FROM table2);