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;