title: MySQL Inner Join Update
body: <p>I am trying to perform a relational update using an innjer join and can't seem to get the syntax correct.</p>
  
  <p>The rows are as follows:</p>
  
  <pre><code>Catalogue.Category_ID
  Catalogue.Visible
  
  Categories.Category_ID
  Categories.Category_Name
  </code></pre>
  
  <p>I am trying to update the value of the visible field when the category ID numbers match and correspond the the correct name.</p>
  
  <pre><code>UPDATE `Catalogue` 
  SET `Visible` = '0' 
  FROM `Catalogue` 
  INNER JOIN `Categories` 
    ON Catalogue.Category_ID = Categories.Category_ID 
    AND Categories.Category_Name = 'Bases'
  </code></pre>
  
  <p>Apologies if it comes down to a stupid syntax mistake, i'm not the most experienced with relational databases.</p>