title: Update from existing table in Redshift
body: <p>I would like to update a value in Redshift table from results of other table, I'm trying to run to following query but received an error.</p>
  
  <pre><code>update section_translate
  set word=t.section_type
  from (
  select distinct section_type from mr_usage where section_type like '%sディスコ')t
  where word = '80sディスコ'
  </code></pre>
  
  <p>The error I received:  </p>
  
  <pre><code>ERROR: Target table must be part of an equijoin predicate
  </code></pre>
  
  <p>Can't understand what is incorrect in my query.</p>