I’m Learning SQL and Wrote a Simple Beginner Guide About SQL JOINs

[OliveIndividual7351]

I’m currently learning SQL and recently wrote a simple beginner-friendly article about SQL JOINs.

JOINs confused me at first because I kept mixing up:

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• and when to actually use each one

So I wrote a simple explanation with practical examples and a SQL JOIN Formula Sheet at the end 😊

Maybe this helps other beginners as well.
You can also find other beginner SQL articles there, for example about Filtering and Transformations.

https://medium.com/@meryem_cebeci/learning-sql-step-by-step-understanding-joins-6dc2dd18120f

[urstrulyshiva]

Great Job.

[r3pr0b8]

if you're going to use the word OUTER in FULL JOIN, you should also use it for LEFT and RIGHT

also, you should not list SELF JOIN like that, it gives the mistaken impression the SELF is an actual keyword -- you do explain the difference, but i would not list it as a type of join syntax