title: Insert fields from one table to another in SQL Server 2005
body: <p>I have a table from which I need to insert some of its data into another table.</p>
  
  <p>I have tables "Provider" and "1_MAIN - Contacts" (I know really bad name, lets just call it "Main" in this discussion). The 2 tables are linked by a column named "Contact_ID". All records in the Provider table have a record in the Main table with a matching "Contact_ID".</p>
  
  <p>The "Providers" table has 4 columns called "geri", "adol", "adult", and "pedi". These fields are datatype <code>bit</code> with a default value of <code>0</code>.</p>
  
  <p>I have created 4 new columns in "Main" with the same names and want to pull the values from the "Provider" table into the "Main" table.</p>
  
  <p>So basically what I want to accomplish is this:</p>
  
  <p>If a "Main" record has a record in "Provider" then grab the values of the "geri", "adol", "adult", and "pedi" columns from its "Provider" record and copy them into its "Main" record.</p>