title: Adding a new column with data from a join
body: <p>What is the best approach to add a column to an existing table with values from a join...For example:  </p>
  
  <p>If I join Table A to Table B...  </p>
  
  <pre><code>Select
  A.Column1,
  A.Column2,
  B.Column1,
  B.Column2,
  B.Column3
  FROM A
  INNER JOIN B
  ON A.Column1 = B.Column2
  </code></pre>
  
  <p>Basically I just want to copy the column that exists in Table B over to Table A, how can I add new A.Column3 to Table A to match B.Column3 based on the join?</p>