SQL JOIN Visualizer

Watch INNER, LEFT, RIGHT, and FULL join run on real rows. Toggle a mode and see exactly which rows survive and where NULL shows up, instead of memorizing a Venn diagram.

Everything happens on your device. Nothing you type here is sent anywhere.

1. The two source tables

Two small tables on purpose. A couple of rows do not match on either side, so every join type produces a different, real result.

customers

orders

2. Pick a join type

3. The result

Matched: found in both tables Customer only: no matching order Order only: no matching customer

4. The SQL