SQL SELF JOIN

The SQL Server Self is used to Join Table 1 to Itself. If we have the Primary key and Foreign key in the same table, then we can use this SQL Self Join one to connect them, and the syntax is shown below. SELECT Tab1.Column(s), Tab2.Column(s), FROM Table1 AS Tab1, Table1 AS Tab2 For this … Read more