Track · 1:00 · Liner note

INNER JOIN Inner Peace

Name: INNER JOIN Inner Peace
Duration: 1 min
Description: An INNER JOIN returns only the rows that have a matching key in both tables, dropping anything unmatched on either side.

An INNER JOIN returns only the rows that have a matching key in both tables, dropping anything unmatched on either side.

An inner join keeps what matches and lets the rest go without comment. That is either peace or data loss, depending on whether you checked what was left behind. INNER JOIN Inner Peace is the calm of knowing you did.

Count the rows on each side, look at the orphans, then decide if dropping them is correct. When it is, the query is tighter, the result is honest and the anxiety about null-filled columns disappears. Acceptance works best with evidence.