The association between two tables that share a field with matching values; the matching fields allow the tables to be joined, so that a query can select data from both tables.