title: Why did this UPDATE change all rows instead of just one row?
body: <p>I have made some SQL code to (what I thought) would update 1 field for only some records. The code I made was: </p>
  
  <pre><code>UPDATE Name
  SET name.STATUS = 'a'
  WHERE EXISTS
      (SELECT Name.ID,
              Name.MEMBER_TYPE,
              Name.CATEGORY,
              Name.STATUS,
              Name.COMPANY_SORT,
              Name.FULL_NAME,
              Name.TITLE,
              Name.FUNCTIONAL_TITLE,
              Activity.ACTIVITY_TYPE,
              Activity.PRODUCT_CODE,
              Activity.TRANSACTION_DATE
       FROM Name
       INNER JOIN Activity ON Name.ID = Activity.ID
       WHERE ACTIVITY_TYPE = 'ELECTIONS'
         AND PRODUCT_CODE LIKE '%new%'
         AND TRANSACTION_DATE LIKE '%2014%'
         AND name.MEMBER_TYPE IN ('mcm',
                                  'MCNM'))
  </code></pre>
  
  <p>but it updated all the records in the name name to the status of <code>a</code>, not just the one in the where exist statement ... what have I screwed up?</p>