title: how to update specific row using inner join?
body: <p>I need to update a specific row in a table, to select this row i need to use inner join, I wrote this:</p>
  
  <pre><code>UPDATE Items
  SET  [Seq] = '0'
  WHERE EXISTS
  (SELECT *
  FROM Items
  inner join Dictionary on  items.Member = Dictionary.Member WHERE
   Items.ID = '1' and Items.Member ='23')
  </code></pre>
  
  <p>All rows in <strong>Items</strong> table were updated, not the specific row (the select statement works fine and I get the row I need) </p>
  
  <p>Do I miss something?</p>