title: How do I lookup a value in a table and insert lookup result in the same table?
body: <p>I created a table from a CSV file. Although the table has all the data we could ever need for this project, the resulting table is not normalized. My task is to clean and normalize this table.</p>
  
  <ol>
  <li><p>Given a field value Value1 from TableA, how do I lookup that value in TableB and place the PK from TableB in a FK column in TableA?</p></li>
  <li><p>Same as Question 1 exception I need to lookup multiple columns. Given field values Value1 and Value2 from TableA, how do I lookup that combination in TableB and place the PK From TableB in a FK column in TableA?</p></li>
  </ol>