title: sql update and join
body: <p>I have a table (in phpmyadmin) that i want to update. </p>
  
  <p>The table is called categories, which has fields ID, Name &amp; sid</p>
  
  <p>I want to update the Name column with the value contained in the table called vocabulary.</p>
  
  <p>Vocabulary contains sid, langid &amp; value</p>
  
  <p>I have worked out the select join statement as follows:</p>
  
  <pre><code>Select categories.ID, vocabulary.value
  FROM categories
  Inner join vocabulary
  on categories.sid = vocabulary.sid
  where langid = 1;
  </code></pre>
  
  <p>However, as i said, i want to update the name field in categories with the corrosponding value from vocabulary.</p>
  
  <p>So i have tried a number of queries but none seem to work</p>
  
  <pre><code>Update categories
  set cateogires.Name = vocabulary.value
  Inner join vocabulary
  on categories.sid = vocabulary.sid
  where langid = 1;
  </code></pre>
  
  <p>Any ideas?</p>