An association between a field in one table or query and a field of the same data type in another table or query. A join tells how data in one table (the foreign table) is associated with data in another table (the primary table).