title: update two tables in single query in mysql
body: <p>I have two tables named <code>supply</code> and <code>equipment</code>. These two tables have a common field named: <code>IAR_NO</code></p>
  
  <p>Now, what I want is to update using a single <em>query</em>, all the records from both tables which have 0 in its <code>IAR_NO</code>.</p>
  
  <p>what could be the best query for this?</p>
  
  <p>I am currently using but does not work</p>
  
  <pre><code>update supply, equipment 
  set supply.IAR_NO =  "9", equipment.IAR_NO= "9 " 
  where equipment.IAR_NO = 0 and supply.IAR_NO = 0
  </code></pre>