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