JOIN operations

The JOIN operations perform joins between two tables.

The JOIN operations are among the possible tableExpressions in a FROM clause. (You can also perform a join between two tables using an explicit equality test in a WHERE clause, such as WHERE t1.col1 = t2.col2.)

The JOIN operations are:

In all cases, you can specify additional restrictions on one or both of the tables being joined in outer join clauses or in the WHERE clause.

JOIN expressions and query optimization

For information on which types of joins are optimized, see Tuning Derby.

Related concepts
SQL identifiers
Built-in system functions
Built-in system procedures
Data types
Related reference
Capitalization and special characters
SQL clauses
SQL expressions
SQL queries
Built-in functions
SYSCS_DIAG diagnostic tables and functions