MS SQL Basics Tutorial: Nested queries

A query that has nested another SELECT statement in a WHERE clause or a HAVING clause in a SELECT statement is called a nested query, also called a subquery. A subquery is an extension of an SQL statement in the form of a statement as follows:

SELECT < target expression 1>[, ...]

From < table or view name 1>

WHERE [Expression] (SELECT < target expression 2>[,...]

From < table or view name 2) >

[GROUP BY < group conditions >

Having [< expressions > comparison operators] (SELECT < target expression 2>[,...]

From < table or view name 2>)]

See the full set of "MS SQL Basics Tutorials"