SELECT
EmailAddress,c.FirstName, c.LastName, Job_Role__c, Consent_Level_Summary__c,
Company_Name__c,
c.AMC_Last_Activity_Date__c,c.AMC_Status__c,c.AMC_Last_Activity_Record_ID__c
FROM  ent.Contact_Salesforce_1 c 
INNER Join [Hydrogen_Webinar_Consent_Query] i ON i.EmailAddress = c.Email
 

WHERE EXISTS (
SELECT [EmailAddress] FROM [Hydrogen_Webinar_Consent_Query] i WHERE i.EmailAddress = c.Email )
 
AND c.Consent_Level_Summary__c in ('Express Consent' , 'Validated Consent')
    AND c.AMC_Status__c = 'Active'
    AND c.AMC_Last_Activity_Record_ID__c <> 'Not Marketable'