Oracle PL/SQL Self-Join

Self-Join is a select query of a table by herself after a given condition.

Self-Join Example 1:

Select *
From customers cust, customers buyer
Where cust.customer_id = buyer.buyer_id;

Self-Join Example 2:

Select *
From customers cust, customers supplier
Where cust.customer_id = supplier.supplier_id;