title: How to create a table, import joined columns, and insert the data in to the new table?
body: <p>I have used a JOIN to put together a query that uses columns from multiple tables.  I want to use that query to insert the appropriate data in a new table.  </p>
  
  <p>I see the columns I want and I know how to create a new table (before the join statements).  I have seen many examples how to create the table and then the JOIN the columns.  How do I get all 160k records in to that table?  </p>
  
  <p>OK here is the query I have so far....</p>
  
  <p>-- Select appropriate columns</p>
  
  <pre><code>SELECT AP.[ApprovedID], AP.[TermID], AP.[SchoolID], AP.[CipCode]
     , CX.[JobCode],  DE.[DOECode], AP.[SA_Level], AP.[CreditHours]
     , AP.[IsActive], AP.[NONVOCED], AP.[CreateDate], AP.[CreatedBy]
     , AP.[LastUpdateDate], AP.[LastUpdatedBy], AP.[Designator], AP.[ChangeFlag]
  </code></pre>
  
  <p>-- Put it into a new table</p>
  
  <pre><code>INTO [INTERS_2004].[inters].[inters_tblApprovedProgramsTest]
  </code></pre>
  
  <p>-- Put in the joins here</p>
  
  <pre><code>FROM [INTERS_2004].[inters].[inters_tblApprovedPrograms] AP
  JOIN [INTERS_2004].[inters].[inters_tblCIPDOECrosswalk] CX
     ON AP.[CipCode] = CX.[JobCode] 
  JOIN [INTERS_2004].[inters].[inters_tblDOECode] DE
     ON CX.[DOECode] = DE.[DOECode]
  
  ORDER BY AP.[ApprovedID]
  </code></pre>
  
  <p>....and at that point my knowledge fizzles in to the air...</p>