# Working with Sub-Queries

Working with Sub-Queries: Types of Sub-Queries, Where to use Sub-Queries.

Updated: November 16, 2026

1. [Types of Sub-Queries](https://www.ask-codey.com/lessons/working-with-sub-queries-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.
2. [Where to use Sub-Queries](https://www.ask-codey.com/lessons/working-with-sub-queries-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.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/working-with-sub-queries
