title: Inserting values into a table based on column values of another table
body: <p>I would like to insert data into a table based on all the values of a secondary table's column. For example</p>
  
  <p>I have two tables </p>
  
  <pre><code>CREATE TABLE Table1 (
  id int identity(1, 1) not null,
  FullName varchar(100),
  Age int,
  CourseID int
  </code></pre>
  
  <p>)</p>
  
  <pre><code>CREATE TABLE Table2 (
  id int identity(1, 1) not null,
  Courses int
  </code></pre>
  
  <p>)</p>
  
  <p>I would like to perform something like this .. </p>
  
  <pre><code>insert into Table1 ('Auser',20,'And the list of Courses that I get from Table2')
  </code></pre>
  
  <p>Is there a way I can do this in sql server ? </p>