UPDATE contact join company on contact.FK_Company = company.PK_Company
SET contact.Mailer = 'PeriodicNews',
    contact.Mailer_Date = '2018-04-23'
WHERE
   NOT contact.Unsubscribe
   AND NOT contact.Bounced
   AND NOT contact.Spam_Filter
   AND (contact.Primary_E_Mail LIKE '%@yahoo.com'
          OR contact.Primary_E_Mail LIKE '%@aol.com')
   AND contact.SPM_Contact
   AND company.Customer
   AND company.Business_State in ('ME', 'VT', 'NH', 'MA', 'RI', 'CT', 'NY', 'NJ', 'PA','DE', 'MD')
;

UPDATE contact join company on contact.FK_Company = company.PK_Company
SET contact.Mailer = 'PeriodicNews',
    contact.Mailer_Date = '2018-04-23',
    company.Customer = company.Customer /*** This is the new line ! ***/
WHERE
   NOT contact.Unsubscribe
   AND NOT contact.Bounced
   AND NOT contact.Spam_Filter
   AND (contact.Primary_E_Mail LIKE '%@yahoo.com'
          OR contact.Primary_E_Mail LIKE '%@aol.com')
   AND contact.SPM_Contact
   AND company.Customer
   AND company.Business_State in ('ME', 'VT', 'NH', 'MA', 'RI', 'CT', 'NY', 'NJ', 'PA','DE', 'MD')
;