SQL JOIN Visualizer

Edit test data directly, chain multiple tables, and see exactly how each join type behaves. Runs entirely in your browser.

How to use:

  1. Edit sample data in the tables or add your own rows and columns
  2. Select a join type (INNER, LEFT, RIGHT, FULL, CROSS)
  3. Choose the join condition and operator
  4. See the visual Venn diagram and resulting rows
  5. Copy the generated SQL for your queries

Edit the tables below to see how different joins behave.

Tables

Join step

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

LR

Generated SQL

SELECT *
FROM customers
INNER JOIN orders ON customers.id = orders.customer_id;

Result (3 rows)

customers.idcustomers.nameorders.idorders.customer_idorders.product
1Alice1011Widget
1Alice1021Gadget
2Bob1032Gizmo

SQL Formatter

Beautify messy SQL into clean, readable queries instantly.

CSV to SQL

Turn pasted CSV data into ready-to-run INSERT statements.

JSON ↔ SQL

Convert JSON arrays to SQL and SQL results back to JSON.

UUID Generator

Generate UUIDs and dummy rows for seeding test tables.