join
A SQL (Structured Query Language) query operation that combines records from two tables and returns them in a result set based on the values in the join fields. Without additional qualification, join usually refers to the join in which field values are equal. For example, customer and order tables are joined on a common field such as customer ID. The result set contains combined customer and order records in which the customer IDs are equal. For example, Figure G-76 shows joins in the query editor in e.Report Designer Professional.
Related terms
field, query, query editor, result set, SQL (Structured Query Language), table, value
Contrast with
inner join, join condition, outer join, SQL SELECT statement
