liveBook · Manning

Inner join

An inner join is a relational operation that returns combinations of rows only when the join condition matches records in both input relations.

How 3 Manning books explain it

DuckDB in Action

An inner join returns row pairs whose join condition matches on both input relations.

How it is used
Combines related tables in practical data workflows such as readings, systems, prices, and exported files.
How deep it goes
Explains matching, USING, and duplicate-key behavior, relating joins to Cartesian products without developing join internals further.
Examples
Demonstrates VALUES relations, equal-key output, duplicate keys, readings-and-systems aggregation, and chained CSV joins.
What you can do after
Apply it via DuckDB SQL to retain only matching rows while combining tables, virtual relations, subqueries, or files.

Read how DuckDB in Action explains inner join →

Build Financial Software with Generative AI (From Scratch)

An inner join is a relational query operation that returns only rows having matching values in both joined relations.

How it is used
Uses inner joins to assemble ACH file and batch API results from related tables.
How deep it goes
Explains matching requirements through queries and a missing-record failure, without detailing join implementation internals.
Examples
Uses invalid ACH files and company records without addresses or phone numbers to illustrate missing matches.
What you can do after
Diagnose/debug missing API results by checking join requirements and choosing left joins for optional records.

Read how Build Financial Software with Generative AI (From Scratch) explains inner join →

Pandas Workout: 200 exercises to make you a stronger data analyst

A join operation that retains only index or key values present in every input table.

How it is used
Aligns oil, ice-cream, and travel time series before correlation analysis.
How deep it goes
Defines index intersection, contrasts missing-value alternatives, and demonstrates chained joins without covering join internals.
Examples
Uses daily oil prices, monthly ice-cream prices, and monthly miles traveled.
What you can do after
Apply it via pandas DataFrame.join to create an aligned table for downstream analysis.

Read how Pandas Workout: 200 exercises to make you a stronger data analyst explains inner join →

Also covered in

What to know first

Related concepts

Questions about inner join

What is inner join?

An inner join is a relational operation that returns combinations of rows only when the join condition matches records in both input relations.

Which Manning books explain inner join?

DuckDB in Action, Build Financial Software with Generative AI (From Scratch) and Pandas Workout: 200 exercises to make you a stronger data analyst.

What should I know before learning inner join?

Manning books that teach inner join usually introduce missing value, SQL and database table first.

What is the difference between inner join and left join?

An inner join is a relational operation that returns combinations of rows only when the join condition matches records in both input relations. A left join combines two relations while retaining every row from the left relation and including matching rows from the right, with nulls for unmatched right-side values.

What is inner join a kind of?

Inner join is a kind of join. A join is an operation that combines records or data elements from multiple inputs according to matching or related values or conditions.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.