2.1. INNER JOIN

Returns records with matching values in both tables.

An INNER JOIN is a type of SQL join that combines rows from two or more tables based on a related column between them. It retrieves only those records that have matching values in both tables. This means that if you're referencing entries from two tables, only the entries that have corresponding matches in both tables will be shown in the results.

Imagine you have a list of customers and a list of orders. An INNER JOIN will show you only those customers who have placed orders. If a customer has not made any orders, they will not appear in the final list, just like only showing students who have enrolled in a specific course rather than a whole class list.

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

In this SQL query, we are selecting the customer's name and their corresponding order ID from two tables named 'customers' and 'orders'. The INNER JOIN operation happens on the condition that the customer IDs in the customers table match the customer IDs in the orders table. The ON clause specifies the relationship between the two tables.

Think of it like a matching game. You have one set of cards with customer names and another set with order IDs. The INNER JOIN is like pairing each customer card with their respective order card, ensuring that you only keep pairs where there is a card from each set.

INNER JOIN is commonly used for combining data that shares a relationship, such as customers and their orders, or employees and their departments.

INNER JOINs are widely used in database management to retrieve meaningful combined data from various sources. For example, if a business wants to see which customers made purchases, INNER JOIN helps combine the customer data with transaction data, ensuring only customers with orders are included.

Imagine a restaurant where you want to find out which dishes customers ordered. You have a list of dishes and a list of customer orders. An INNER JOIN here will help you see only the dishes that were actually ordered by customers, excluding those that were never requested.

--