Denis Gobo : left joinhttp://sqlblog.com/blogs/denis_gobo/archive/tags/left+join/default.aspxTags: left joinenCommunityServer 2.1 SP2 (Build: 61129.1)Teaser: Left Join..the SQL ego crusherhttp://sqlblog.com/blogs/denis_gobo/archive/2009/08/04/15746.aspxTue, 04 Aug 2009 13:42:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15746Denis Gobo6http://sqlblog.com/blogs/denis_gobo/comments/15746.aspxhttp://sqlblog.com/blogs/denis_gobo/commentrss.aspx?PostID=15746http://sqlblog.com/blogs/denis_gobo/rsscomments.aspx?PostID=15746One of the more difficult things to master for people coming to SQL seems to be the Outer Join. The common mistake people make is of course putting the condition in the WHERE clause from the outer joined table which should have been in the JOIN itself....(<a href="http://sqlblog.com/blogs/denis_gobo/archive/2009/08/04/15746.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=15746" width="1" height="1">left join