Sql Join Same Table

Table

Sql Join Same Table

Pic12 JPG
Understanding Table Joins using SQL CodeProject from sql join same table , source:codeproject.com