An INNER JOIN returns rows with matching values in both tables.
An INNER JOIN will return only the rows where there is a match in both tables based on the specified condition. For instance, to find customers who have placed orders, you would use an INNER JOIN to combine the 'customers' and 'orders' tables, ensuring only those with orders are included.