The JOIN operations, which are among the possible
The JOIN operations are:
Specifies a
join between two tables with an explicit join clause. See
Specifies a
join between two tables with an explicit join clause, preserving unmatched
rows from the first table. See
Specifies a
join between two tables with an explicit join clause, preserving unmatched
rows from the second table. See
In all cases, you can specify additional restrictions on one
or both of the tables being joined in outer join clauses or in the
For information
on which types of joins are optimized, see