| |
|
|
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.
|
|