A Data Science Central Community
Back when I was learning SQL, I was often hung up on the JOIN concept. The venn diagrams were a life saver but as I learned more and used SQL more and more I found that they were not quite enough.
I worked with some of my colleagues at the Data School to try to go a little bit further.
We were trying to keep it VERY basic so some join types and antijoins are not included.
I would love to know what you all think.
For the full write up: https://dataschool.com/sql-join-types-explained-visualizing-sql-joi...