title: Redshift table update with join
body: <p>I have 3 table t1, t2 and t3.<br>
  t1 has 2 column-> id1, val1  </p>
  
  <pre><code>t2 -&gt; id2, val2  
  t3 -&gt; id3, val3  
  If id1=id2 and id2 = id3 
  </code></pre>
  
  <p>then I need to update val1 ad val3.
  But I have repeating id1 and each should have same val3</p>
  
  <p>I am using   </p>
  
  <pre><code>update  t1
  inner join  t2 on t1.id1 = t2.id2
  inner join  t3 on t2.id2 = t3.id3
  set t1.val1 =  t3.val3
  ;
  </code></pre>
  
  <p>But not able to do this.</p>