SQL

Visual JOIN Diagrams

See SQL JOINs row-by-row — hover any row or hit play to watch the join happen live

Interactive April 2026

INNER JOIN: Returns only rows where both tables have a matching key. C003, C004, and O003 vanish — no match found.

freshcart_db · 4 customers · 4 orders

customers (left table)

idnametier

C001Emma JohnsonGold

C002Liam WilliamsSilver

C003Olivia BrownPlatinum

C004Noah GarciaBronze

orders (right table)

idcust_idamount

O001C001

$42.90

Organic Milk

O002C002

$31.50

Bread & Eggs

O003C005

$78.20

Pantry Bundle

O004C001

$19.80

Fresh Produce

hover any row to see its connections · or click play to animate

// Result

3 rows returned

cust.idnamecityorder_idamount

C001Emma JohnsonNew YorkO001$42.90

C001Emma JohnsonNew YorkO004$19.80

C002Liam WilliamsChicagoO002$31.50

// SQL

INNER JOIN

SELECT c.name, c.city, o.id, o.amount
FROM customers c
INNER JOIN orders o ON c.id = o.customer_id;

// Quick reference

// Try it yourself

Write real JOIN queries against the FreshCart database in your browser — no install needed.

Discussion

Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.