© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
M. SimonLeveling Up with SQLhttps://doi.org/10.1007/978-1-4842-9685-1_3

3. Table Relationships and Joins

Mark Simon1  
(1)
Ivanhoe VIC, VIC, Australia
 

A database is not just one table. Well, it can be of course, but any sophisticated database, such as one which you would use to manage an online bookshop, will comprise a number of tables, each handling a different collection of data.

While you can get some useful information from examining individual tables, you will get so much more from combining tables.

In this chapter, we will look at working with multiple tables, how they are related to each other, and how to combine them when the time comes.

Specifically, ...

Get Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.