EP_SegmentRegion

SELECT mst.SubscriberKey,mst.EmailAddress, mst.Consent_Level_Summary__c, mst.FirstName, mst.LastName, mst.CreatedDate, 
mst.Mailing_Country__c, mst.Region, mst.SegmentRegion, 
CASE WHEN mst.Job_Role__c = 'Consulting Engineer' THEN 'Consulting Engineer'
WHEN mst.Job_Role__c = 'Consultant Engineer' THEN 'Consulting Engineer'
WHEN mst.Job_Role__c = 'Contracting/Consulting' THEN 'Consulting Engineer'
ELSE 'Other'
END as Job_Role__c

FROM ep_mr_en_us_w170049_MASTER mst
LEFT JOIN ep_mr_en_EAME_VSP_eBlast hb ON mst.subscriberkey=hb.subscriberkey
WHERE mst.SegmentRegion = 'EU'