Joins & Subqueries
Documentation on the JOIN, UNION, EXCEPT and INTERSECT clauses, and on subqueries.
-
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.
