Documentation on the JOIN, UNION, EXCEPT and INTERSECT clauses, and on subqueries.
| Title | Description |
|---|---|
| Joins | Querying from multiple tables |
| Subqueries | Queries within queries |
| 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. |
| UNION | Combine the results from multiple SELECT statements into a single result set. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/joins-subqueries/