从多个表中插入表 [英] INSERT INTO Table from multiple tables

问题描述

嘿，我有一个连接两个不相关表的Junction表.两个表都具有ID.我需要使用具有不同值的WHERE从每个表中选择ID，例如，这就是我的看法:

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");

我所见过的所有示例都使用join语句，但是两个表具有相同的值，在这种情况下，它们却没有.

All the examples I've seen use a join statement but the two tables have a common value, in this case they don't.

推荐答案

尝试以下查询:

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

这篇关于从多个表中插入表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！