SQL Fundamentals, Third Edition

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.

Introduction to Joins		475
13-1	A query can use data from several tables	475
13-2	The best approach is to join two tables at a time	477
Inner Joins of Two Tables		479
13-3	A one-to-one relationship	479
13-4	A many-to-one relationship	483
13-5	A one-to-many relationship	485
13-6	A many-to-many relationship	487
13-7	Unmatched ...