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
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter