SQL from Zero to Pro #7: Joins (INNER, LEFT, RIGHT, FULL JOIN)

If you’ve ever worked with several tables, you’ve surely needed to cross-reference their data. That’s exactly what joins do: they link information spread across different tables to get useful results. What you'll learn Visualize joins before writing them INNER JOIN, LEFT JOIN and RIGHT JOIN, with prefixes and aliases Emulate a FULL OUTER JOIN in MySQL with UNION Replace a subquery with a join Visualizing joins The easiest way to understand joins is a circle diagram (like the ones on sql.sh), before you even write the query. With two tables A and B: ...

November 19, 2026 · 5 min · 935 words · Naimi