Hi, Jim Hudson – oaktreeit.com. Today we’re going to take a look at the — mostly the conceptual difference between an inner and a left outer join. Anytime you’re working with any kind of data, especially relational data, you’re going to see the concept of a join.
Let’s a paint a familiar scenario: You’re a mid-level employee for a fairly established company. You pride yourself on being a punctual, cordial, and skilled employee who delights in a job well done. Despite this, a colleague of yours has no such pride. They are frequently late, their work lacks quality, and their attitude could use some adjustment. Plainly put, while you smile and greet them in the morning, you have Force-choked them like Darth Vadar many times in your mind.