title: Update on INNER JOIN not working
body: <p>I am trying to update a table in Redshift from another table by using inner join. </p>
  
  <p>Query:</p>
  
  <pre><code>UPDATE target 
  INNER JOIN updates ON target.name = updates.name and target.title = updates.title and target.age = updates.age 
    SET target.num_hit_ratio = updates.num_hit_ratio, target.plan_id = updates.plan_id;
  </code></pre>
  
  <p>This is giving error:</p>
  
  <blockquote>
    <p>syntax error at or near "INNER"</p>
  </blockquote>
  
  <p>Where am I making mistake?</p>