Mixing
How can I exclude email addresses from a data extension that are not part of a different data extension in...
I have a data extension (DE) with email addresses. (A data extension is basically a database table). However I want to take out the email addresses that also show up on a different DE (and the resulting email addresses + other data will have to be stored in a third DE), so basically exclude/suppress them.
I know I can use suppression lists [1] when sending an email, but I need to know how many recipients I will have before I'm actually clicking the send button... I'm looking for a SQL solution.
[1] = https://help.salesforce.com/articleView?id=mc_es_suppression_lists_in_your_send.htm&type=5
sql
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
add a comment |
I have a data extension (DE) with email addresses. (A data extension is basically a database table). However I want to take out the email addresses that also show up on a different DE (and the resulting email addresses + other data will have to be stored in a third DE), so basically exclude/suppress them.
I know I can use suppression lists [1] when sending an email, but I need to know how many recipients I will have before I'm actually clicking the send button... I'm looking for a SQL solution.
[1] = https://help.salesforce.com/articleView?id=mc_es_suppression_lists_in_your_send.htm&type=5
sql
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
2
Which DB are you using?
– Aaron_ab
Jan 1 at 15:17
Is '[1] = url' where you want to place the sql script in?
– Yakov R.
Jan 1 at 15:56
add a comment |
I have a data extension (DE) with email addresses. (A data extension is basically a database table). However I want to take out the email addresses that also show up on a different DE (and the resulting email addresses + other data will have to be stored in a third DE), so basically exclude/suppress them.
I know I can use suppression lists [1] when sending an email, but I need to know how many recipients I will have before I'm actually clicking the send button... I'm looking for a SQL solution.
[1] = https://help.salesforce.com/articleView?id=mc_es_suppression_lists_in_your_send.htm&type=5
sql
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
I have a data extension (DE) with email addresses. (A data extension is basically a database table). However I want to take out the email addresses that also show up on a different DE (and the resulting email addresses + other data will have to be stored in a third DE), so basically exclude/suppress them.
I know I can use suppression lists [1] when sending an email, but I need to know how many recipients I will have before I'm actually clicking the send button... I'm looking for a SQL solution.
[1] = https://help.salesforce.com/articleView?id=mc_es_suppression_lists_in_your_send.htm&type=5
sql
sql
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
asked Jan 1 at 15:10
Jonathan Van DriessenJonathan Van Driessen
612
612
2
Which DB are you using?
– Aaron_ab
Jan 1 at 15:17
Is '[1] = url' where you want to place the sql script in?
– Yakov R.
Jan 1 at 15:56
add a comment |
2
Which DB are you using?
– Aaron_ab
Jan 1 at 15:17
Is '[1] = url' where you want to place the sql script in?
– Yakov R.
Jan 1 at 15:56
2
2
Which DB are you using?
– Aaron_ab
Jan 1 at 15:17
Which DB are you using?
– Aaron_ab
Jan 1 at 15:17
Is '[1] = url' where you want to place the sql script in?
– Yakov R.
Jan 1 at 15:56
Is '[1] = url' where you want to place the sql script in?
– Yakov R.
Jan 1 at 15:56
add a comment |
1 Answer
1
active
oldest
votes
I found the answer:
So let's say your table with email addresses is called SourceDE and the table which has the email addresses to be excluded is called ExcludeDE with a field email, then you can do something like:
/* get the fields */
SELECT
SourceDE.email,
SourceDE.firstName
FROM SourceDE
/* join the two tables, but then only keep the rows
where there is no matching email address from the ExcludeDE */
LEFT JOIN ExcludeDE
SourceDE.email on ExcludeDE.email
WHERE
ExcludeDE.email = NULL
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53996550%2fhow-can-i-exclude-email-addresses-from-a-data-extension-that-are-not-part-of-a-d%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I found the answer:
So let's say your table with email addresses is called SourceDE and the table which has the email addresses to be excluded is called ExcludeDE with a field email, then you can do something like:
/* get the fields */
SELECT
SourceDE.email,
SourceDE.firstName
FROM SourceDE
/* join the two tables, but then only keep the rows
where there is no matching email address from the ExcludeDE */
LEFT JOIN ExcludeDE
SourceDE.email on ExcludeDE.email
WHERE
ExcludeDE.email = NULL
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
add a comment |
I found the answer:
So let's say your table with email addresses is called SourceDE and the table which has the email addresses to be excluded is called ExcludeDE with a field email, then you can do something like:
/* get the fields */
SELECT
SourceDE.email,
SourceDE.firstName
FROM SourceDE
/* join the two tables, but then only keep the rows
where there is no matching email address from the ExcludeDE */
LEFT JOIN ExcludeDE
SourceDE.email on ExcludeDE.email
WHERE
ExcludeDE.email = NULL
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
add a comment |
I found the answer:
So let's say your table with email addresses is called SourceDE and the table which has the email addresses to be excluded is called ExcludeDE with a field email, then you can do something like:
/* get the fields */
SELECT
SourceDE.email,
SourceDE.firstName
FROM SourceDE
/* join the two tables, but then only keep the rows
where there is no matching email address from the ExcludeDE */
LEFT JOIN ExcludeDE
SourceDE.email on ExcludeDE.email
WHERE
ExcludeDE.email = NULL
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
I found the answer:
So let's say your table with email addresses is called SourceDE and the table which has the email addresses to be excluded is called ExcludeDE with a field email, then you can do something like:
/* get the fields */
SELECT
SourceDE.email,
SourceDE.firstName
FROM SourceDE
/* join the two tables, but then only keep the rows
where there is no matching email address from the ExcludeDE */
LEFT JOIN ExcludeDE
SourceDE.email on ExcludeDE.email
WHERE
ExcludeDE.email = NULL
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
answered Jan 3 at 19:21
Jonathan Van DriessenJonathan Van Driessen
612
612
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53996550%2fhow-can-i-exclude-email-addresses-from-a-data-extension-that-are-not-part-of-a-d%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Which DB are you using?
– Aaron_ab
Jan 1 at 15:17
Is '[1] = url' where you want to place the sql script in?
– Yakov R.
Jan 1 at 15:56