A join shows how data is related between two tables. When two tables contain matching values on a field, records from the two tables can be combined by defining a join. For example, suppose one table has the weight of objects with their associated part number and another table has part numbers and their associated product names. A join specifies that the two part number fields are equivalent and enables weights and product names to be related.

See also, STATISTICA Query, Join Overview, Join Operators.