re: SQL 201: All about SQL JOINs VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Helen … Thanks for the quick examples (here and elsewhere). I think you should expand on what LEFT Vs RIGHT JOIN mean (ie. the table specified fi...
 

Hi Dale

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!

Helen

code of conduct - report abuse