title: How to Update on table with another table
body: <p>I have two tables table_A and Table_B</p>
  
  <p>Table_A</p>
  
  <pre><code>ID    Col1    Col2   Col3
  123    2      A      JIM
  456    2      A      JACK
  </code></pre>
  
  <p>Table_B</p>
  
  <pre><code>ID    Col1    Col2   Col3
  123    1       B      KIM
  456    1       B      LEE
  </code></pre>
  
  <p>Query Using:</p>
  
  <pre><code>Update Table_A a, Table_B b
  Set  a.Col1 = b.Col1,
       a.Col2 = b.Col2,
       a.Col3 = b.Col3
  where a.ID = b.ID
  </code></pre>
  
  <p>Current Results:
  Getting error</p>
  
  <p>Required Results:</p>
  
  <p>I want to update value of Table 1 with value of Table 2.</p>