title: UPDATE STATEMENT :[Amazon](500310) Invalid operation: Target table must be part of an equijoin predicate;
body: <p>I get this error Target table must be part of an equijoin predicate 
  if I use OR operator in my update statement.I tried IN operator also but getting same error,</p>
  
  <p>My original update query is</p>
  
  <pre><code>UPDATE db.table1 
  SET    col1 = table2.col1, 
         col2 = table2.col2 
  FROM   table2 
  WHERE  ( col3 = table2.col3 
            OR col3 = table2.col4 ) 
         AND col5 = 'some string';
  </code></pre>
  
  <p>I tried using IN operator but getting same error</p>
  
  <pre><code>UPDATE db.table1 
  SET    col1 = table2.col1, 
         col2 = table2.col2 
  FROM   table2 
  WHERE  col3 IN ( table2.col3, table2.col4 ) 
         AND col5 = 'some string'; 
  </code></pre>
  
  <p>what will be the alternative of OR in Redshift update statement?</p>