title: Create new table by combining two existing (insert two foreign keys)
body: <p>I created a table that consists of two foreign keys. I want to fill the table with default values from the two related tables. They look like this:</p>
  
  <pre><code>+---------------+
  | Table A       |
  +---------------+
  | id            |
  | other info... |
  +---------------+
  
  +---------------+
  | Table B       |
  +---------------+
  | id            |
  | level         |
  | other info... |
  +---------------+
  </code></pre>
  
  <p>I want the new table to be populated so that every A has a relation to every B. How can I do this with a MySQL UPDATE statement?</p>