INSERT INTO Table from multiple tables

mysql, sql

Solution

Try this query:

     INSERT INTO C (aID, bID) 
     SELECT A.ID, B.ID 
     FROM A, B 
     WHERE A.Name='Me'
     AND B.Class='Math';

Problem

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

Original source