Loading…
Loading…
Edit test data directly, chain multiple tables, and see exactly how each join type behaves. Runs entirely in your browser.
Edit the tables below to see how different joins behave.
Step 1: customers ⋈ orders
Returns only rows where the join condition matches on both sides.
3 matched pairs • 1 unmatched in customers • 1 unmatched in orders
SELECT * FROM customers INNER JOIN orders ON customers.id = orders.customer_id;
| customers.id | customers.name | orders.id | orders.customer_id | orders.product |
|---|---|---|---|---|
| 1 | Alice | 101 | 1 | Widget |
| 1 | Alice | 102 | 1 | Gadget |
| 2 | Bob | 103 | 2 | Gizmo |
JOIN Visualizer is a free learning tool that shows exactly how SQL joins behave. Edit the sample tables, pick a join type and condition, and see the matching rows and a Venn diagram update live — then copy the equivalent SQL query.
Yes. The JOIN Visualizer is completely free with no signup and no usage limits, like all SqlInt mini tools.
Up to 3 tables chained across 2 join steps. Each step can reference any earlier table, so table 1 can join table 3 directly.
INNER, LEFT, RIGHT, FULL OUTER, and CROSS joins with =, !=, >, <, >=, and <= operators — with Venn diagrams and live result rows.
No. Every mini tool processes data locally in your browser — pasted text and uploaded files never leave your device.
Catch anti-patterns, implicit joins, and style issues in your SQL.
Beautify SQL live with instant preview across 7 dialects.
Turn CSV into CREATE TABLE + INSERTs with auto-detected types.
Convert JSON arrays to SQL — and INSERTs back to JSON — live.