Cheat Sheet logoCheat Sheet Today
SQLite Joins, CTEs, and Window Functions Cheatsheet/Use an INNER JOIN

Return rows that match in both tables.

Back to sheetBrowse commands
Sign in to save
Section: Join tables

Use an INNER JOIN

sql
sql
SELECT p.id, p.title, u.email
FROM posts p
JOIN users u ON u.id = p.user_id;
Explanation

The most common join pattern for parent-child data.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Join tables
Use a LEFT JOIN
Keep parent rows even if the child is missing.
OpenIn sheetsqlsame section
Join and aggregate
Count child rows per parent.
OpenIn sheetsqlsame section
Use a CTE to stage a subquery
Name an intermediate result set.
OpenIn sheetsql1 tag match
Use a recursive CTE
Walk a hierarchy such as categories or folders.
OpenIn sheetsql1 tag match
Assign row numbers
Rank rows within an ordered result.
OpenIn sheetsql1 tag match
Compute a running total
Use SUM() OVER for cumulative metrics.
OpenIn sheetsql1 tag match