Contents Index How joins work The FROM clause

ASA SQL User's Guide
  Joins: Retrieving Data from Several Tables

Joins overview


A join is an operation that combines the rows in tables by comparing the values in specified columns. This section is an overview of Adaptive Server Anywhere join syntax. All of the concepts are explored in greater detail in later sections.


The FROM clause
Join conditions
Joined tables
Joining two tables
Joining more than two tables
Join compatible data types
Using joins in delete, update, and insert statements
Non-ANSI joins

Contents Index How joins work The FROM clause