SQL Joins Visualized

A beginner friendly guide using graphics.

We can all agree Joins are some of the most inevitable statements in SQL regardless of where you find yourself in terms of processes surrounding data merging, data retrieval, data manipulation, ETL, and so on. There are two components, one is understanding the different types of joins, and the other, is distinguishing which to apply according to specific needs. I was once in those tragic shoes of numerous trials and errors before selecting the best fit (very inefficient practice).