O'Reilly logo

SQL for Microsoft Access, 2nd Edition by Neal A. Berkowitz, Cecelia L. Allison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required