title: update table1 by getting values from two tables
body: <p>I am using mysql database 
  Want to update table1 on specific condition by fetching values from two or more tables 
  example </p>
  
  <pre><code>            table1 
              id | stdId | trId | std_name | std_lname |std_edu_college |std_edu_cource
              01 | 1256  | 2341 |
  
  
  
              student table
              stdId | name | lname 
              1256  |Mallu |Malage
  
  
  
              student_education table
              stdId | college | cource 
              1256  | BEC     | Engineering
  </code></pre>
  
  <p>Want to update table1 with student and student_education data</p>
  
  <p>Like this i have around 100 columns in table1 with different column name 
  I know using update table1 by joining and set each respected column but i want to update like looping or easy way So someone please help me</p>