title: Update Fields in one table if fields in another are not equal
body: <p>I have one table of customer information - <code>[Customer Alignments]</code> that is the master table. </p>
  
  <p>As things process, there is another table that compiles customer information at the point of helping the customer. This is called <code>[tCC Master]</code></p>
  
  <p>So, what I would like to do is take this <code>[tCC Master]</code> table and check to see if the information in the <code>[Customer Number]</code> and <code>[Therapy]</code> fields differ from the <code>[Customer Alignments]</code>. If they do, I want to update these fields to display the new <code>[Customer Number]</code> and/or <code>[Therapy]</code> from <code>[tCC Master]</code></p>
  
  <p>i.e.:</p>
  
  <pre><code>[Customer Alignments]
  
   - Number - Therapy - Location Number
   - 1 - ABC - 1234
   - 2 - BCD - 5678
   - 3 - YES - 9101
   - 4 - ABC - 0246
  
  [tCC Master]
  
   - Number - Therapy - Location
   - 1 - BCD - 1234
   - 5 - QWE - 5678
   - 3 - YES - 9101
   - 6 - ABC - 0246
  </code></pre>
  
  <p>This is what I have, but I'm not sure about it</p>
  
  <pre><code>UPDATE [dbo].[ru_t_Customer Alignments]
  
  SET [dbo].[ru_t_Customer Alignments].[Customer Number] = [dbo].[ru_tCC_Master].[Customer Number] (@[dbo].[ru_t_Customer Alignments].[Customer Number], [dbo].[ru_t_Customer Alignments].[Customer Number])
       , [dbo].[ru_t_Customer Alignments].[Therapy] = [dbo].[ru_tCC_Master].[Therapy] (@[dbo].[ru_t_Customer Alignments].[Therapy], [dbo].[ru_t_Customer Alignments].[Therapy])
  
  FROM [dbo].[ru_t_Customer Alignments], [dbo].[ru_tCC_Master]
  
  WHERE [dbo].[ru_t_Customer Alignments].[Customer Number] &lt;&gt; [dbo].[ru_tCC_Master].[Customer Number] OR [dbo].[ru_t_Customer Alignments].[Therapy] = [dbo].[ru_tCC_Master].[Therapy];
  </code></pre>
  
  <p>If someone could help point me to a solution, that would be wonderful. 
  Thank you!</p>