title: updating two tables with a single query
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/4361774/mysql-update-multiple-tables-with-one-query">MySQL, update multiple tables with one query</a>  </p>
  </blockquote>
  
  
  
  <p>I'd like to know how to update two different tables with a single query, using MySql and C#.</p>
  
  <p>Here is my query to read the data from the database.</p>
  
  <pre class="lang-sql prettyprint-override"><code>string sql = @"SELECT clb.clube AS nome, clb.email AS email, clb.telefone AS 
  telefone, usr.login AS login, usr.senha AS senha 
  FROM clubes AS clb 
  INNER JOIN usuarios AS usr ON usr.nome = clb.clube 
  WHERE usr.login = @log";
  </code></pre>
  
  <p>Note that I get the data from <code>usr</code> and <code>clb</code>. Now, I'd like to update it. How can I do that? </p>