Chapter 8Creating Table Joins and Unions
Introduction
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.
Definitions
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 ...
Get SQL for Microsoft Access, 2nd Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.