Oracle Tutorial

Self Join Examples

Example 1

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

Example 2

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