AN ORIGINAL MANUSCRIPT SAMPLE

The Mental Model of a Join

Who it is for: Analysts and developers who want to understand what their queries do.

Working manuscript · 2027–2028 Edition. The full book is forthcoming; text and illustrations may change.

Part I operated on one table at a time. A join combines related rows from two tables into wider result rows. This chapter develops a physical model for that operation before introducing the syntax used to express it.

Read the chapter

The preview below shows the first 3 pages. The PDF contains the complete 11-page chapter, with selectable text and the original illustrations.

Download sample chapter (PDF) ↓Open PDF in a new tab ↗

Illustrated SQL, The Mental Model of a Join, original page 52 — Original manuscript page 52 · Illustrated SQL

Illustrated SQL, The Mental Model of a Join, original page 53 — Original manuscript page 53 · Illustrated SQL

Illustrated SQL, The Mental Model of a Join, original page 54 — Original manuscript page 54 · Illustrated SQL

Keep exploring Illustrated SQL

See how a query changes your data. Follow a small shop’s dataset from simple filters to joins, aggregations, and window functions.

See the book outline →

Questions or corrections? support@hackerbrewery.com