Working with Sub-Queries
Working with Sub-Queries: Types of Sub-Queries, Where to use Sub-Queries.
Updated
- Types of Sub-Queries (Journeyman): The difference between an uncorrelated sub-query, which runs once on its own, and a correlated sub-query, which runs once for each row of the outer query.
- Where to use Sub-Queries (Journeyman): Where a sub-query can go, as a lookup value or list in WHERE, an EXISTS check, a column value, or a table to join.