Subscribe to DSC Newsletter

Explaining SQL JOINS - Improving on the Classic Venn Diagrams

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...

Views: 904

Reply to This

On Data Science Central

Follow Us

© 2018   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service