SELECT c.id,c.Consent_Level_Summary__c,c.AMC_Status__c,c.CreatedDate,c.LastModifiedDate, c.AMC_Last_Activity_Record_ID__c FROM ENT.Contact_Salesforce_1 as c INNER JOIN Mining_opt_outs t ON c.id = t.SF_ID WHERE CONSENT_LEVEL_SUMMARY__C <> 'Revoked Consent'
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