---
schema_version: "1"
id: 2e0a0b2b8726a84e277b710364cff3e865f4d99201172d33044d95f90b60f657
title: Data Relationships
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_es_data_relationships.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_relationships.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1ae9b49dc3413a0dd2d0051881cab3f3e14022d7642a5d4f8cf933ae1880de13
description: A data relationship in Email Studio specifies that a column in one data extension contains the same kind of information as a column in another data extension or in a subscriber attribute. Use a data relationship to relate two data extensions based on a common column contained in both data extensions. You can then apply a filter to the two data extensions and create a new segment of data.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data Relationships

A data relationship in Email Studio specifies that a column in one data extension contains the same kind of information as a column in another data extension or in a subscriber attribute. Use a data relationship to relate two data extensions based on a common column contained in both data extensions. You can then apply a filter to the two data extensions and create a new segment of data.

Usually, the column is the primary key of one of the data extensions. For example, if you store an airport code as a subscriber attribute and create a data extension that contains airport names related to the airport codes, you would create a data relationship to declare that the airport code on the subscriber contains the same kind of information as the airport code in the data extension. This process allows the relationship to find the airport name by looking up the row in the data extension that contains the same airport code as the subscriber attribute.

![Relationship between Subscribers and Airports Data Extensions](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_email-264-0-0-production-enus/a0b807ef-dfbb-412c-b26e-310d91f2d6df/mc_email/images/data_relationship.png)

You can relate multiple columns from each table to use multiple values to identify the correct row in the related table.

Before you create a data relationship, you must create the data extensions that are involved in the relationship. After you create a data relationship, you can include information from the data extension in messages to subscribers via a data filter.

- **[Create a Data Relationship in Marketing Cloud Engagement](https://help.salesforce.com/s/articleView?id=mktg.mc_es_create_data_relationship.htm&release=264.0.0&type=5)**  
    Create a data relationship between data extensions in Email Studio.
- **[Troubleshoot Marketing Cloud Engagement Data Relationships](https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_relationship_troubleshooting.htm&release=264.0.0&type=5)**  
    Review this information to troubleshoot your data relationships for data extensions in Email Studio.