A connection between multiple tables where records from related fields that match are combined and shown as one record. Records that don't match may be included or excluded, depending on the type of join.