An Explanation of SQL Joins
Recently I had to analyze several Stored Procedures and Views in SQL 2008 to find out why a process had stopped working. Many of you have had to do the same thing and this stuff gets complicated. So along with my several pages of notes I found this article particularly useful. This is the best representation and explanation of SQL Joins I have found and wanted to share.
http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/
Andrew Skovran
Support Engineer
ImageSource, Inc.