SQL SERVER- Differences Between Left Join and Left Outer Join | Journey to SQL Authority with Pinal

Hi Pinal, I just came across the following scenario today and wanted to get it clarified from you. I know there is no difference between left and left outer join but however the result set was different in my scenario. Bascially I joined two tables using

blog.sqlauthority.com