I like sql and sometimes I go overboard by normalizing my database too much. At that point, I need to rely on JOIN to get the data what I want. Issue is that I never remember how JOIN works: RIGHT JOIN, LEFT INNER JOIN, OUTER JOIN, 🤯. I’ve had an image on my ~/Desktop/ for years.

Here is the full version of the image

It has been hanging on my Desktop for almost 6 years since I got the laptop. Then 2021 arrived: new year, new laptop (finally, thanks M1 chip). Now come the decision: move the file over to my new Desktop or drop it or …

Since I decided to be building one thing a month for 2021, here we go: an interactive version of this image!

Give it a try: join.oertel.fr

Edit 2022-06-13: I found a more descriptive way to show the differences between JOINs: twitter.com/alexxubyte/status/1535280913797394434