Contents Index Shortcuts for compound search conditions Introduction

ASA Getting Started

Selecting Data from Multiple Tables


About this chapter 

This chapter describes database queries that look at information in more than one table. To do this, SQL provides the JOIN operator. There are several different ways to join tables together in queries, and this chapter describes some of the more important ones.


Introduction
Joining tables using the cross product
Using the ON phrase to restrict a join
Joining tables using key joins
Joining tables using natural joins
Joining tables using outer joins

Contents Index Shortcuts for compound search conditions Introduction