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.

freshmart_db · 4 customers · 4 orders

customers (left table)

idnametier

C001Ravi KumarGold

C002Meera PatelSilver

C003Arjun SinghPlatinum

C004Priya NairBronze

orders (right table)

idcust_idamount

O001C001

₹1,240

Rice 5kg

O002C002

₹890

Vegetables

O003C005

₹2,100

Groceries

O004C001

₹560

Fruits

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

// Result

3 rows returned

cust.idnamecityorder_idamount

C001Ravi KumarHyderabadO001₹1,240

C001Ravi KumarHyderabadO004₹560

C002Meera PatelMumbaiO002₹890

// 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 FreshMart database in your browser — no install needed.

Discussion

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