This is just a simple article visually explaining SQL JOINs. In this article I am going to discuss seven different ways you can return data from two relational tables. The seven Joins I will discuss are: Inner JOIN, Left JOIN, Right JOIN, Outer JOIN, Left Excluding JOIN, Right Excluding JOIN, Outer Excluding JOIN, while providing examples of each.
Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
No alternatives have been posted.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.