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

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.