Have you heard of SELF JOIN?

SELF JOIN is an operation in SQL where a table is joined with itself. It is useful when you need to compare rows within the same table or retrieve related data from one table.

For example, if there is an employees table with a manager_id column indicating their manager (who is also in the same table), you can use a SELF JOIN to get the manager's name for each employee:

SELECT e.name AS employee, m.name AS manager
FROM employees e
LEFT JOIN employees m ON e.manager_id = m.id;