title: How to update record using mysql join?
body: <p>In my mysql I am having t1, t2 tables and I want to update t1's field from t2's field value based on t1's field value match t2's field value </p>
  
  <p>I tried the below but it is not updating. What I did wrongly here</p>
  
  <pre><code>UPDATE t1 
  INNER JOIN t2 
  ON t1.name = t2.name 
  SET t1.age = t2.age 
  WHERE t1.name IS NOT NULL;
  </code></pre>