Join

A Join combines data from two or more data sources into a new data source.

Technically, a join is a query that combines rows from two or more tables, views, or materialized views. For example, a Join combines tables or views (specified in a FROM clause), selects only rows that meet specified criteria (WHERE clause), and uses projection to retrieve data from two columns (SELECT statement).

For information about joins in Oracle Database, see the SQL discussion in Oracle Database Concepts.

The following topics describe the Join node: