title: Using MySQL: Update field with values using Inner Join
body: <p>I have a main table and an index table. Both tables share a common primary field called "L_Status". I want to update the data in the main table from "L_Status" values (integers) into "L_StatusLV" (readable text values) based on the reference in the index table called "status". Here is the code I've entered into PHPmyAdmin to accomplish this: </p>
  
  <pre><code>UPDATE markers.L_Status 
  FROM markers
  INNER JOIN STATUS ON markers.L_Status = status.L_Status
  WHERE  markers.L_Status = status.L_StatusLV
  </code></pre>
  
  <p>PHPmyAdmin returns the following error: </p>
  
  <blockquote>
    <p>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM markers INNER JOIN STATUS ON markers.L_Status = status.L_Status WHERE ma' at line 2</p>
  </blockquote>
  
  <p>Any advice on the sytax error here? </p>