title: How can we update two different tables with single sql query?
body: <p>How can we update two tables with single sql query?</p>
  
  <p>Suppose I have two tables</p>
  
  <pre><code>1. Employee
  
  empid  empname     salary
  00001   Vijay      100000
  00002   Alex       200000
  00003   Jennifer   300000
  
  
  2. Institute
  
  regno    State        Country
  123ab    Texas          USA
  231nf    California     USA
  </code></pre>
  
  <p>So how can we update both tables lets say I want to update "salary" field of "empid" 00001 of "Employee" table and the "State" field of "regno" 123ab of Institute table.</p>