Mining Check

PHOTO EMBED

Wed Oct 19 2022 15:01:45 GMT+0000 (Coordinated Universal Time)

Saved by @rogerstamara 

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'
content_copyCOPY