SQL – Self Join Explained
This tutorial will explain why a self join is used in SQL and how to create a self join query. Knowledge of how to write inner, left, and right joins is needed before continuing with this tutorial. This tutorial uses MySQL as the database management system in the examples. However, many other DBMS’s such as …