Join operations enable you to retrieve data from two or more tables or views in the same database or in different databases in a single operation.
This section shows how to formulate several varieties of joins, including equijoins and outer joins. For details on subqueries (queries nested within other queries), which also can involve two or more tables, see Using Subqueries.