# Joins & Subqueries

- [EXCEPT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/except.md)
- [INTERSECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/intersect.md)
- [MINUS](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/minus.md)
- [Precedence Control in Table Operations](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/precedence-control-in-table-operations.md)
- [UNION](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/union.md)
- [Joins](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins.md): Learn about SQL joins. This section details various join types (INNER, LEFT, RIGHT, FULL) to combine rows from two or more tables based on related columns, enabling complex data retrieval.
- [JOIN Syntax](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins/join-syntax.md)
- [More Advanced Joins](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins/more-advanced-joins.md)
- [Comma vs JOIN](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/joins/comma-vs-join.md)
- [Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries.md): Learn about subqueries in MariaDB Server. This section details how to use nested queries to perform complex data retrieval, filtering, and manipulation operations within a single SQL statement.
- [Subqueries and ALL](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-all.md)
- [Subqueries and ANY](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-any.md)
- [Subqueries and EXISTS](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-exists.md)
- [Subqueries and JOINs](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-joins.md)
- [Subqueries in a FROM Clause (Derived Tables)](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-in-a-from-clause-derived-tables.md)
- [Row Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-row-subqueries.md)
- [Scalar Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-scalar-subqueries.md)
- [Subquery Limitations](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subquery-limitations.md)
