A type of join that returns records from two tables using matching values in the join field. Records for which there is no matching value are not included in the result set. For example, joining customer and order tables where the customer IDs are equal produces a result set that excludes records for customers who have no orders.