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 ...