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:

Equijoin Band Join Self Join Cartesian Products Inner Join Outer Join Semijoin

PreviousSelect Flashback Query NextEquijoin

Last updated 7 months ago