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.