Joins

A join is a query that combines rows from two or more tables, views, or materialized views. Oracle Database performs a join whenever multiple tables appear in the FROM clause of the query. (Oracle SQL Language Reference JOINS)

Here are the articles in this section:

pageEquijoinpageBand JoinpageSelf JoinpageCartesian ProductspageInner JoinpageOuter JoinpageSemijoin