InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Self Join In Sql Server Joins? |
|
Answer» 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 has a hierarchical reporting structure whereby one MEMBER of staff reports to another. Self Join can be Outer Join or Inner Join. 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 has a hierarchical reporting structure whereby one member of staff reports to another. Self Join can be Outer Join or Inner Join. |
|