Ultimate Guide to SQL Joins

Understand what, why, and how to use joins in SQL, with many examples, so you feel confident when working with SQL joins.

Learn what a join is, why we need them, and how to write one

See many examples of SQL joins... and not just basic examples. Learn how the more complex joins work as well.

You'll get answers to many frequently asked questions about joins in SQL.

A PDF Guide to SQL Joins

Joins are one of the foundational concepts when working with databases and SQL.

But they can be a hard concept to understand...

In this guide, you'll learn:

What is a join, why you need them, and many examples of joins
How to actually write a join, with examples and explanations of "simple" joins with two tables, as well as joins with multiple tables and different types of joins
Answers to many common questions that you and others have about joins in SQL