Question: Are JOINs supported in DESelect?
Answer: Yes, JOINs are available in DESelect. When you create a relationship between data extensions by drag-and-drop, different kinds of relationships can be defined. Here is the overview of the possible types of JOINs that are available in DESelect:
|
Name |
Description |
Example |
SQL Query |
|
A WITH/WITHOUT MATCHING B |
Match or don’t match data extension A with data extension B |
Returns a list of contacts (A) combined, whether or not they have a matching account (B) |
Left Join |
|
A WITH MATCHING B |
Only match data extension A with data extension B |
Return only the contacts (A) that have a matching account (B) |
Inner Join |
|
B WITH/WITHOUT MATCHING A |
Match or don’t match data extension B with data extension A |
Return all accounts (B) whether or not they have matching contacts (A) |
Right Join |
|
A WITH ALL B |
Match all of data extension A with data extension B |
Return all contacts (A) with all accounts (B) |
Full Outer Join |
|
A WITHOUT MATCHING B |
data extension A without data extension B |
Return the contacts (A) that don’t have a matching account (B) |
Exclusive Left Join |
|
B WITHOUT MATCHING A |
data extension B without data extension A |
Return the accounts (B) that don’t have a matching contact (A) |
Exclusive Right Join |
| EACH FROM A WITH EACH FROM B
|
A paired combination of each row of Data Extension A with each row of Data Extension B
|
Returns for each and every contact (A) a paired combination with each and every account (B) |
Cross Join |
Related article: What is a Cross Join?
Comments
0 comments
Please sign in to leave a comment.