title: Best way to add and populate new column with data from second table
body: <p>I have two tables.</p>
  
  <p>Table A is a list of invoices each with a unique invoice ID.</p>
  
  <p>Table B is a list of invoice attributes with a unique invoice ID that corresponds to those in Table A.</p>
  
  <p>I want to add a new column to table A called "Contact Name" by looking up that value by invoice ID in table B.</p>
  
  <p>I know I could create a temp table by joining TableA and TableB, and then replace the existing table with that new one... but I'm curious if there is a better way to do this.</p>