title: How to Update column values of t1 from Table t2?
body: <p>I want to select t2 column values (Name) and update with t1 column values (Name) without where clause. what will be the query?</p>
  
  <p>I am executing below code:</p>
  
  <pre><code>update t1 set t1.name=t2.name from t2 where t1.id=t2.id
  </code></pre>
  
  <p>but I want to perform it without <code>WHERE</code> clause.</p>