Redshift table update with join
<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>