Joins & Subqueries

Documentation on the JOIN, UNION, EXCEPT and INTERSECT clauses, and on subqueries.

Title Description
Joins Querying from multiple tables.
Subqueries Queries within queries.
UNION Combine the results from multiple SELECT statements into a single result set.
EXCEPT Subtraction of two result sets.
INTERSECT Records that are present in both result sets will be included in the result of the operation.
Precedence Control in Table Operations Controlling order of execution in SELECT, UNION, EXCEPT, and INTERSECT.
MINUS Synonym for EXCEPT.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/joins-subqueries/