A. Join a list and a data extension to filter the combined data B. Join three or more data extensions together to create a filtered data extension C. Join data extensions to filter or segment the fields from data extensions D. Join data extensions together to create one combined data extension
A data relationship is a bound situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. Relationships allow relational databases to split and store data in different tables, while linking disparate data items and also automatically access correction on both side.
A bank database for example, a CUSTOMER_MASTER table stores the customer data with a primary key column named CUSTOMER_ID; it also stores the customer data in an ACCOUNTS_MASTER table, which contains different information about various bank accounts and associated customers. So as to link these two tables together and to determine the customer and bank account information, a corresponding CUSTOMER_ID column must be inserted in the ACCOUNTS_MASTER table, referencing existing customer IDs from the CUSTOMER_MASTER table. Which makes the ACCOUNTS_MASTER table’s CUSTOMER_ID column a foreign key that references a column with the same name in the CUSTOMER_MASTER table.