title: INSERT INTO Table from multiple tables
body: <p>Hey so I have a Junction table linking two unrelated tables. Both the tables have <code>ID</code>'s. I need to select the <code>ID</code> from each table using <code>WHERE</code> with different values, for example this is how I see it:</p>
  
  <pre class="lang-sql prettyprint-override"><code>INSERT INTO c (aID, bID)
  VALUES (SELECT a.ID WHERE a.Name="Me", SELECT b.ID WHERE b.Class="Math");
  </code></pre>
  
  <p>All the examples I've seen use a <code>join</code> statement but the two tables have a common value, in this case they don't. </p>