title: How do you create a new table with columns from a dozen different tables
body: <p>I'm trying to help update some code for a non-profit I volunteer with. Someone wrote them a SQL script years ago and it needs updating to work with new tables in their database. I've been trying to follow the patterns in the existing code to add the new tables and the necessary columns from the new table to this script and I can't figure it out. I've been working on this for over a week. Can someone please take a look and please help?</p>
  <p>The part of the script I need help with is</p>
  <pre><code>---CREATE Starting Table
  SELECT
      [Current Year],
      [Agency ID],
      [App Number],
      [Client Number],
      [Last Name],
      [First Name]
  INTO 
      ClientToProcess
  FROM 
      ClientTBLInfo as m;
  </code></pre>
  <p>This script was grabbing information from the columns:</p>
  <pre><code>[Current Year]
  [Agency ID]
  [App Number]
  [Client Number]
  [Last Name]
  [First Name]
  </code></pre>
  <p>which are located in just one table - <code>ClientTBLInfo</code>.</p>
  <p>Over time they've added new tables and columns to the database.</p>
  <p>So now there are about 12 more columns across about 8 different tables beyond the <code>ClientTBLInfo</code> table that needs to be added to this script and I can't figure out how to add these new tables to the script.</p>
  <p>I appended the <code>SELECT</code> statement by adding the new column names to the list. However, I don't know how to append this part of the script where I tell it which tables to look for the new columns in.</p>
  <pre><code>INTO ClientToProcess
  FROM ClientTBLInfo as m;
  </code></pre>
  <p>There's literally like a column from one table that needs to be added and then two columns from a different table, etc.</p>
  <p>Any suggestions on how to do this?</p>
  <p>Thank you in advance.</p>