Chapter 13. Inner Joins

So far, we have obtained data from one table or view, sometimes adding a table of constants. In the next four chapters, we discuss seven different ways to combine two tables. On a conceptual level, the tables are combined first, which creates a single table. Then the techniques we have discussed so far are applied to get a final report from that table.

This chapter discusses inner joins, the most common way to combine two tables.

Get SQL Fundamentals, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.