If we want to join two instances of the same table we can use self-join.
A self-join in a database management system (DBMS) is when a table is joined with itself. This can be useful when you want to compare rows within the same table. For example, in a table representing employees, you might use a self-join to find pairs of employees who share the same manager.