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.