See how INNER JOIN returns only the intersection of two tables with live connector lines and a Venn diagram. Edit keys and watch the result change.
Join type
Data (click a cell to edit)
SELECT * FROM A INNER JOIN B ON A.key = B.key
ON A.key = B.key — empty keys are treated as SQL NULL and never match
Table A
Table B
Result
| A.key | A.val | B.key | B.val |
|---|---|---|---|
| 1 | kim | 1 | dev |
| 3 | park | 3 | hr |
Edit a key or add a row — the connector lines and result update instantly. The 'Duplicate key' preset shows why LEFT JOIN row counts can grow.
INNER JOIN returns only rows where the ON condition holds in both tables. Rows existing on just one side disappear entirely, so the result can be smaller than the driving table.
Watch for the opposite too — with duplicate join keys one row matches multiple partners and the result grows (1:N fan-out). The 'Duplicate key' preset shows A.key=2 fanning out to two rows of B.
Most production JOIN bugs come from silently losing rows with INNER JOIN. During migrations, aggregate with LEFT JOIN first to see the difference before narrowing to INNER. SQL JOIN Visualizer