Subquery Fundamentals - TechNet - Microsoft

A subquery is a SELECT query that returns a single value and is nested inside a ... Many Transact-SQL statements that include subqueries can be alternatively ...

technet.microsoft.com