Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

SQL Joins Cheat Sheet

A 2-page reference for combining tables with joins: 14 short entries with copy-ready code.

ForDevelopers

sql-joins-cheat-sheet.pdfShowing 19 of 75 lines
// INNER JOIN
SELECT o.id, u.name
FROM orders o
JOIN users u ON u.id = o.user_id;

// LEFT JOIN
SELECT u.name, o.id
FROM users u
LEFT JOIN orders o ON o.user_id = u.id;

// Find rows with no match
SELECT u.*
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE o.id IS NULL;

// RIGHT and FULL JOIN
SELECT *
FROM a

What's inside

Format
PDF, Markdown
Contents
14 sections · 2 pages
Version
1.0 · Updated 3 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • sql-joins-cheat-sheet.pdfPDF · 19 KB
  • sql-joins-cheat-sheet.mdMarkdown · 2 KB
  • LICENSE.txtadded to every download

About this item

A compact, printable reference for combining tables with joins. Each of the 14 entries has a one-line explanation and a small example you can paste into your editor. The PDF uses a two-column A4 layout designed to sit next to your keyboard, and the same content ships as Markdown so you can search it or drop it into your notes. Every SQL example targets ANSI SQL / PostgreSQL.

  • SQL
  • Relational
  • Database
  • Joins
  • Cheat sheet

Reviews

No reviews yet.

You might also grab