SQL for Microsoft Access, 2nd Edition

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.

Keywords

DISTINCTROW

INNER JOIN

LEFT JOIN

ON

RIGHT JOIN

UNION

UNION ALL

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