A join is an operation that combines the rows in tables by comparing the values in specified columns. This section is an overview of SQL Anywhere join syntax. All of the concepts are explored in greater detail in later sections.
The FROM clause
Joining two tables
Joining more than two tables
Join compatible data types
Using joins in delete, update, and insert statements