ASA SQL User's Guide
Joins: Retrieving Data from Several Tables
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