inner join
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.
Related terms
field, join, result set, table, value
Contrast with
outer join

Additional Links:

Copyright Actuate Corporation 2012