title: How to summarize the inserted amount of two different queries in a single transaction?
body: <p>When performing two consecutive insert query statements in a single transaction like:</p>
  <pre><code>INSERT INTO MyTable1 
  SELECT * FROM SomeTable1 (100 rows)
  
  INSERT INTO MyTable2
  SELECT * FROM SomeTable2 (200 rows)
  </code></pre>
  <p>The total amount of affected rows is 200 rows (of the last INSERT statement: &quot;MyTable2&quot;), I was wondering <strong>how to make it to return 300 rows</strong> as the sum of both INSERT statements?</p>