glennonymous

SELECT 
  SFlist.email
FROM
  contact SFlist
JOIN
  account A
  ON SFlist.accountid = A.id
  AND A.region_forecasting__c = 'US/ROW'
  AND A.industry IN(
    'Retail',