‹
EXPLORE · LISTEN · DISCOVER

Left outer join

Technology · Organizing recordsVISUAL DISCOVERY 1025 OF 1,100

Left outer join

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

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

A left join preserves every left-side row even when no matching right-side row exists.

Ask the child to explain left outer 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 Every left row survives; the unmatched row has NULL fields
A little wonder
HERE’S A LITTLE WONDER…

What makes left outer join work?

You are reviewing a sketch that uses left outer 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.