Python · SQL · Web Dev · Java · AI/ML tracks launching soon — your one platform for all of IT

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.

Open SQL Playground →
Share

Discussion

0

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

Continue with GitHub
Loading...