RSS‎ > ‎

SQL :: What is Self Join?

posted Sep 19, 2012, 11:47 PM by Ashish Jain
This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can be of any type, as long as the joined tables are the same. A self join is rather unique in that it involves a relationship with only one table. The common example is when company have a hierarchal reporting structure whereby one member of staff reports to another.