title: MySQL - Update selected data
body: <p>I have sort of a translation database. One table with words and their IDs in language A (langA), one with words and IDs in language B (langB) and one that connects the words in both languages (translation), like ID-idA-idB.</p>
  
  <p>In order to display a translation by translation ID I use a joined table:</p>
  
  <pre><code>SELECT * 
  FROM langA, langB, translation
  WHERE translation.id = 5 
      AND langA.id = translation.idA 
      AND langB.id = translation.idB
  </code></pre>
  
  <p>The last two lines are because one word may have more than one translation. </p>
  
  <p>Now I'd like to update the information for a certain translation by its ID. Seems it would be easiest to update what I just selected. </p>
  
  <p>I found a syntax like this</p>
  
  <pre><code>UPDATE langA
  SET langA.word = 'newword'   
  FROM langA, langB, translation
  WHERE translation.id = 5 
      AND langA.id = translation.idA
      AND langB.id = translation.idB
  </code></pre>
  
  <p>However, this gives me an error "near 'langA, langB, translation WHERE translation.id = ...'"</p>
  
  <p>What am I doing wrong?</p>