SQLite SELF-JOIN allows you to join a table to itself. It is a special JOIN type in SQLite.
SELECT name AS 'manager', name AS 'report' FROM staff e INNER JOIN staff m ON m.id = e.manager ;
SQLite SELF-JOIN clauses are generally used for parent-child relationships derived from a single table. Another general use of SELF-JOINs are running totals.