Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Multiple Tables

Multiple Tables

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, artists and 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.

Report a Bug
If you see a bug or any other issue with this page, please report it here.