问题描述
我想根据辅助表列的所有值将数据插入到表中.例如
I would like to insert data into a table based on all the values of a secondary table's column. For example
我有两张桌子
CREATE TABLE Table1 ( id int identity(1, 1) not null, FullName varchar(100), Age int, CourseID int
)
CREATE TABLE Table2 ( id int identity(1, 1) not null, Courses int
)
我想执行这样的操作..
I would like to perform something like this ..
insert into Table1 ('Auser',20,'And the list of Courses that I get from Table2')
有没有办法在 sql server 中做到这一点?
Is there a way I can do this in sql server ?
推荐答案
那么对于一位新用户,您想插入所有可用的课程吗?
So for one new user you want to insert all available courses?
INSERT INTO Table1 SELECT 'Ausser', 20, t2.Courses FROM Table2 t2;
这是小提琴:http://sqlfiddle.com/#!3/89470/1/0