In PostgreSQL By Ziemek 20 April 2018 Ziemek

SQL Joins Explained visually

Explained joins visually

When I explain SQL joins to people in person, I use my hands to show these very same ideas.

If you are looking for a more comprehensive explanation check out my post Stop guessing, SQL joins explained.