INNER JOIN

INNER JOIN returns rows that have matching values in both tables.

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

• Only rows with a match in both orders and customers are returned.