---
schema_version: "1"
id: 6839416cd3b9e41abf6b92678374166b2522de28687e784613d16f60d70c40ff
title: Create a Join Between Engagement and Data Extension Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_data_extension_join.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_data_extension_join.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ea9a103306cb1d8a994c4ab0fb61746ffed621ae7291355f8d5400a246df4fc2
description: While connecting to a data extension, you can create a connection between the data extension and engagement data. This way when querying, you’re pulling in data from both datasets.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Join Between Engagement and Data Extension Data

While connecting to a data extension, you can create a connection between the data extension and engagement data. This way when querying, you’re pulling in data from both datasets.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Intelligence Reports Advanced</td></tr></tbody></table>

This step is optional and is only necessary if you want to query your data extension data with your engagement data using the Query Builder. If you want to query your data extension as a standalone table without engagement data, then don’t create a join.

There are two different types of joins

- **Left Join**—Returns all records from the left table, and the matched records from the right table. This is the default type.
- **Full Join**—Returns all records when there’s a match in either the left or right table.

Use this example, which demonstrates subscriber data, to understand what happens when selecting each join type. You can perform the join on any field.

**Engagement Data**

 
| Subscriber Key | Sends |
| --- | --- |
| abc123 | 1 |
| def123 | 1 |
| aaa222 | 1 |

**Data Extension Data**

 
| ID | Region |
| --- | --- |
| abc123 | EMEA |
| def123 | AMER |
| 123456 | AMER |
| aaa222 | EMEA |

Since the values are stored in different fields in the data extension and in the engagement data, you must ensure that the fields are connected. If subscriber data is represented as the subscriber key in your engagement data, and as contact ID in the data extension data, connect the fields like this:

![data\_extension\_example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_data_management_and_analytics-264-0-0-production-enus/7988f60d-cd94-4b42-8836-dc11773564b5/mc_data_management_and_analytics/images/mc_data_extension.png)

By default, the system performs a left join. If you run the query, you get these results based on the type of join you select.

**Left Join Results**

  
| ID | Region | Sends |
| --- | --- | --- |
| abc123 | EMEA | 1 |
| def123 | AMER | 1 |
| aaa222 | EMEA | 1 |

**Full Join Results**

  
| ID | Region | Sends |
| --- | --- | --- |
| abc123 | EMEA | 1 |
| def123 | AMER | 1 |
| aaa222 | EMEA | 1 |
| 123456 | AMER | NULL |