根据另一个表的列值将值插入表中

问题描述

我想根据辅助表列的所有值将数据插入到表中.例如

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