title: Table aliasing in update statement in RedShift
body: <p>I have a sql statement which is as follows which I am trying to convert to Redshift. </p>
  
  <pre><code>update #tmpHist l 
  set spread = lh.spread
  from table1 lh 
  where  
      l.id=lh.id 
  </code></pre>
  
  <p>But it gives error as:</p>
  
  <pre><code>[Amazon](500310) Invalid operation: syntax error at or near "l" 
  </code></pre>
  
  <p>Is there a way to alias table without specifying entire table.</p>