Sean Lange (11/30/2015)

---

robert.sterbal 56890 (11/30/2015)

---

robert.sterbal 56890 (11/30/2015)

---

Images:

https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746

Search:

https://www.google.com/search?q=venn+diagram+left+outer+join

It is redundant, but is used quite frequently:

http://stackoverflow.com/questions/2389204/left-inner-join-vs-left-outer-join-why-does-the-outer-take-longer

Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is about somebody discussing LEFT INNER join which is almost as elusive as a gold pot carrying leprechaun or a flying unicorn. 😀