SQL JOIN Visualizer

See which rows survive a join and how one-to-many matches expand your results.

Make it work with your data.

Left table CSV

Or choose a CSV fileLocal processing · up to 2 MB / 50,000 rows

Right table CSV

Or choose a CSV fileLocal processing · up to 2 MB / 50,000 rows

Left join key

Right join key

Join type

HOW TO USE IT

SQL JOIN Visualizer

Edit the two small tables, select matching key columns, and switch the join type. The output colors identify matched and unmatched rows.

What to know

This visualizer uses exact, case-sensitive string equality. Empty key cells represent NULL and never match each other. SQL database collations and type coercion may differ. Duplicated keys produce all matching combinations. Outputs are limited to 10,000 rows.

← Explore all tools