Understanding SQL self-join.

Understanding SQL self-join.

References

Reference NO 1

http://stackoverflow.com/questions/15194344/understanding-sql-self-join

Reference NO 2

http://www.udel.edu/evelyn/SQL-Class3/SQL3_self.html

Reference NO 3

http://www.programmerinterview.com/index.php/database-sql/what-is-a-self-join/

Reference NO 4

http://blog.sqlauthority.com/2010/07/08/sql-server-the-self-join-inner-join-and-outer-join/

Reference NO 5

http://www.tutorialspoint.com/sql/sql-self-joins.htm

Reference NO 6

http://www.w3resource.com/sql/joins/perform-a-self-join.php

Reference NO 7

http://technet.microsoft.com/en-us/library/ms177490(v=sql.105).aspx

Reference NO 8

http://databases.about.com/od/sql/a/selfjoins.htm