Thanks for all your comments, I appreciate the feedback.
You’re right, I could have given more of an explanation as to what I meant by LEFT and RIGHT. The image doesn’t speak for itself so it could have been clearer.
The Cross join is more of a warning than anything else. As you say, things can get out of hand very quickly.
I included Unions at a very high level to show that you can ‘join’ tables both horizontally and vertically but agree it is a blog post on its own.
Thank you for suggestions too, I’ll be posting a few more data blog posts before the year is out!
We’re a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.