Difference between Inner join and Self Join

An inner join (sometimes called a simple join) is a join of two or more tables that returns only those rows that satisfy the join condition.

A self join is a join of a table to itself. This table appears twice in the FROM clause and is followed by table aliases that qualify column names in the join condition. To perform a self join, Oracle Database combines and returns rows of the table that satisfy the join condition.