Chapter 8Creating Table Joins and Unions
In this chapter, you will learn how to retrieve records from multiple tables using table joins and unions. You will also learn how to create table aliases, perform qualification, create a Cartesian product, and implement the DISTINCTROW keyword.
Cartesian product — Result produced when each row in one table is multiplied by the total number of rows in another table.
INNER JOIN — Used to instruct the DBMS to combine matching values from two tables.
LEFT JOIN — Selects every record from the table specified to the left of the LEFT JOIN keywords.
ON — Used to specify a condition.
Qualification — Used to match ...