‹
EXPLORE · LISTEN · DISCOVER

Inner join

Technology · Organizing recordsVISUAL DISCOVERY 1024 OF 1,100

Inner join

Explorer · about 8 minutes · a little curiosity goes a long way

Lesson details
Browse all adventures
For grown-ups
Today’s little discovery

An inner join pairs rows whose join keys match and leaves unmatched rows out.

Ask the child to explain inner join using the picture, then ask which real-world details the simplified drawing leaves out.

This is a learning model. Try the take-home activity together.
Voice settings

Using Heart (en-US).

Saved voices download ahead of play for this activity. No lesson text is sent to a speech service.The sample plays once and does not change the Sound on/off setting.
Your adventure steps
  1. Wonder
  2. Guess
  3. Try it
  4. Discover
  5. Celebrate
01 / 05
Left: peopleRight: key 4 absent1 · Ada2 · Bo3 · Cy4 · Dee1 · Red2 · Green3 · Blue Only matching pairs appear in the inner-join result
A little wonder
HERE’S A LITTLE WONDER…

What makes inner join work?

You are reviewing a sketch that uses inner join. Follow its parts through a small change before deciding what to keep in the design.

No rush. Try an idea and see.
Try it

Open Lesson to read the question, choose your idea, and continue.