title: mysql - insert into one table from another with conditions from a third table
body: <p>How do you insert into table A all the rows from table B that match a condition from table C?</p>
  
  <p>For instance,<br> </p>
  
  <pre><code>INSERT INTO tableA SELECT * FROM tableB WHERE tableB.id=tableC.id;
  </code></pre>
  
  <p>This does not work, because mysql does not recognize tableC. </p>