Journey to SQL Authority with Pinal Dave Of late, I penned down an article - SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause Effects Resultset in LEFT JOIN - which received a very intriguing c