title: how to update multiple columns in multiple tables
body: <p>How can we update multiple columns in multiple tables in a single query?</p>
  
  <p>I tried the below but no success.</p>
  
  <hr>
  
  <p><a href="https://i.stack.imgur.com/x0llD.jpg" rel="nofollow noreferrer">My tables</a></p>
  
  <pre><code>update Class c, School s
  set c.Status='Absent', s.Status='Absent'
  Where c.ID='&amp;ID' and c.ID=s.ID;
  </code></pre>
  
  <hr>
  
  <p>Any clues are appreciable.</p>