Database Reference
In-Depth Information
Chapter 9. Joining and Subquerying Data
Most of the examples used in this topic thus far have intentionally involved one table per
SQL statement in order to allow you to focus on the basic syntax of each SQL statement.
When developing a MySQL or MariaDB database, though, you will often query multiple
tables. There are a few methods by which you may do that — you've seen some simple ex-
amples of them in previous chapters. This chapter covers how to merge results from mul-
tiple SQL statements, how to join tables, and how to use subqueries to achieve similar res-
ults.
