Tag: postgres
-
Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL
One of the first and most common things newcomers to SQL struggle with is how each JOIN is different from the other. In this article, I’ll explain the differences between the inner vs outer JOIN and left vs right JOIN in SQL using examples from each.