Oracle Joins

Inner Join – is a join of two or more tables that returns only those rows that satisfy the join condition.

Left Outer Join – is a query that performs an outer join of tables A and B and returns all rows from A.

Non Equi-Join – enables you to join two tables where there is no direct correspondence between columns in the tables.

Outer Join – extends the result of a simple join.

Right Outer Join – is a query that performs an outer join of tables A and B and returns all rows from B.

Self Join – is a join of a table to itself.