Self-join is when you need to join a table with itself, for example, when you need to find the manager details for an employee if the manager column has the manager's employee ID.