JOIN
ELI5 — The Vibe Check
JOIN combines rows from two tables based on a related column. If you want to see order details AND the customer name in one result, you JOIN the orders table and the users table together. It is like merging two spreadsheets on a shared column.
Real Talk
A JOIN combines rows from two or more tables based on a related column condition. The most common type is INNER JOIN (only matching rows). Variants include LEFT JOIN, RIGHT JOIN, and FULL JOIN. JOINs are fundamental to querying normalized relational data.
Show Me The Code
SELECT users.name, orders.total
FROM orders
JOIN users ON orders.user_id = users.id
WHERE orders.status = 'completed';
When You'll Hear This
"JOIN the users and orders tables to get the customer name with each order." / "Multiple JOINs on large tables can be slow without indexes."
Related Terms
Foreign Key
A foreign key is how you link two tables together. If an 'orders' table has a 'user_id' column pointing to the 'users' table, that is a foreign key.
FULL JOIN
FULL JOIN returns everything from both tables regardless of whether there is a match. Rows with no match on either side get NULLs.
INNER JOIN
INNER JOIN only returns rows where there is a match in BOTH tables. If a user has no orders, they do not appear in the result.
LEFT JOIN
LEFT JOIN returns all rows from the left table, and matching rows from the right table.
RIGHT JOIN
RIGHT JOIN is LEFT JOIN's mirror image — it returns all rows from the right table, and matching rows from the left.