An operation that establishes a temporary connection between corresponding records in two tables using an item common to both (i.e., relate key). Each record in one table is connected to those records in the other table that share the same value for the common item.
