SQL SERVER – 2005 Explanation and Example – SELF JOIN | Journey to SQL Authority with Pinal Dave

A self-join is simply a normal SQL join that joins one table to itself. This is accomplished by using table name aliases to give each instance of the table a separate name. Joining a table to itself can be useful when you want to compare values in a column to other values in the same… Continue Reading...

Source: SQL SERVER – 2005 Explanation and Example – SELF JOIN | Journey to SQL Authority with Pinal Dave