Oracle Self Join

The Oracle Self Join is a join of a table to itself.

Oracle Self Join example

Select *
From users u, users m
Where m.manager_id = u.user_id
Order By u.user_id;

Select *
From customers c, customers s
Where s.supplier_id = c.customer_id 
Order By c.customer_id;