Home > Transforms Nodes > Filter Columns > 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: