从多个表插入到表中

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.

我有一个连接表连接两个不相关的表。两个表都有ID。我需要从每个表中使用不同的值选择ID，例如，这就是我所看到的。

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.

我看到的所有示例都使用了join语句，但这两个表有一个公共值，在本例中它们没有。

2 个解决方案

#1

Try below:

试试下面:

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

#2

Another way can be

另一种方法可以

INSERT INTO c (aID, bID)
SELECT 
   (SELECT A.id FROM TableA A WHERE A.names = 'sometext'), 
   B.id FROM TableB B 
WHERE 
   B.x_name ='othertext';

#1