join included contacts - remove exclusions

PHOTO EMBED

Tue Apr 23 2024 18:29:05 GMT+0000 (Coordinated Universal Time)

Saved by @shirnunn

SELECT mst.SubscriberKey,mst.EmailAddress, mst.Consent_Level_Summary__c, mst.FirstName, mst.LastName, mst.CreatedDate, 
mst.Mailing_Country__c, mst.SegmentRegion, mst.LanguageCode, mst.AMC_Status__c,mst.Job_Role__c,mst.AMC_Last_Activity_Date__c, mst.Region,mst.Industry_Level_2_Master__c, mst.Industry__c

FROM [ep_mr_en_us_w170049_MASTER] mst
LEFT JOIN [ep_mr_en_us_w170049_Exclusions_Dealers_Agency_Competitor] e ON LOWER(mst.EmailAddress) = LOWER(e.EmailAddress)
WHERE e.EmailAddress IS NULL
content_copyCOPY

join contacts DE