So far we have learned how to build tables, write queries, and perform calculations using one table. In this lesson we will learn to query multiple tables that have relationships with each other.
Most of the time, data is distributed across multiple tables in the database. Imagine a database with two tables,
albums. An artist can produce many different albums, and an album is produced by an artist.
The data in these tables are related to each other. Through SQL, we can write queries that combine data from multiple tables that are related to one another. This is one of the most powerful features of relational databases.