A self-join shine haɗi inda teburin ya haɗi da kansa — mai amfani a lokacin da jere a cikin teburin suna da alaƙa da sauran jere a cikin teburin ɗaya, kamar hierarchies (ma'aikata da masu jiyya su) ko kiyaye jere a cikin teburin.
Misalin gida: ma'aikata da masu jiyya
employees table — manager_id references another employee's id (in the SAME table):
id | name | manager_id
1 | Ann | NULL (Ann is the boss)
2 | Bob | 1 (Bob's manager is Ann)
3 | Carol | 1 (Carol's manager is Ann)
e.name employee, m.name manager
employees e
employees m e.manager_id m.id;
