Why JOINs combine related tables in MySQL - Visual Breakdown

Concept Flow - Why JOINs combine related tables

Start with Table A

↓

Start with Table B

↓

Find matching rows based on join condition

↓

Combine matching rows into one result row

↓

Repeat for all rows in Table A

↓

Output combined rows as result set

JOINs take two tables, find rows that match a condition, and combine those rows into one result row.

Execution Sample

MySQL

SELECT orders.id, customers.name
FROM orders
JOIN customers ON orders.customer_id = customers.id;

This query combines orders with their customers by matching customer IDs.

Execution Table

Step	orders.id	orders.customer_id	customers.id	customers.name	Join Condition Met?	Output Row
1	101	1	1	Alice	Yes	(101, Alice)
2	101	1	2	Bob	No	No output
3	102	2	1	Alice	No	No output
4	102	2	2	Bob	Yes	(102, Bob)
5	103	3	1	Alice	No	No output
6	103	3	2	Bob	No	No output
Exit	-	-	-	-	All rows checked	Query ends

💡 All rows in orders checked against customers; join condition no longer met for new pairs.

Variable Tracker

Variable	Start	After Step 1	After Step 4	Final
Current orders row	None	id=101, customer_id=1	id=102, customer_id=2	id=103, customer_id=3
Current customers row	None	id=1, name=Alice	id=2, name=Bob	id=2, name=Bob
Output rows	Empty	[(101, Alice)]	[(101, Alice), (102, Bob)]	[(101, Alice), (102, Bob)]

Key Moments - 2 Insights

Why do some rows from orders not appear in the output?

Rows from orders only appear if their customer_id matches a customers.id. Rows without a match are skipped, as shown in execution_table rows 3, 5, and 6.

Why does the join condition check both tables' columns?

The join condition connects related rows by comparing columns from both tables. Without this, rows wouldn't combine meaningfully, as seen in the 'Join Condition Met?' column.

Visual Quiz - 3 Questions

Look at the execution_table, what is the output row at Step 4?

A No output

B (101, Alice)

C (102, Bob)

D (103, Alice)

💡 Hint

Check the 'Output Row' column at Step 4 in the execution_table.

At which step does the join condition fail for orders.id=103 and customers.id=2?

A Step 6

B Step 5

C Step 4

D Step 1

💡 Hint

Look at the 'Join Condition Met?' column for orders.id=103 and customers.id=2 in the execution_table.

If orders.customer_id=3 matched customers.id=3, how would the output change?

A No change in output rows

B A new output row would appear for orders.id=103

C All output rows would be removed

D Only orders.id=101 would appear

💡 Hint

Refer to variable_tracker showing output rows after each step.

Concept Snapshot

JOINs combine rows from two tables where a condition matches.
Syntax: SELECT columns FROM A JOIN B ON condition;
Only rows meeting the condition appear combined.
Useful to relate data from different tables.
Without matching, rows are excluded from results.

Full Transcript

JOINs combine related tables by matching rows based on a condition. For example, orders and customers tables join on customer IDs. Each order row is checked against customer rows. When the customer_id in orders matches the id in customers, those rows combine into one output row. Rows without matches do not appear in the result. This process repeats for all rows in the first table. The output is a new table showing combined information from both tables where the join condition is true.