title: SQL get ID of a row on another table that contains the same characters in a certain column
body: <p>I'm practicing some SQL and I came across a situation where I have two tables.  They both have 'name' columns in them and one table has id's and one does not.  I want to grab the id of the name row and add the ID of that row to the other tables same name row.</p>
  
  <pre><code>Table A
  ID, Name
  1, Ryan
  2, Chris
  3, Ben
  
  Table B
  ID, Name
  null, Ryan
  null, Chris
  null, Ben
  </code></pre>
  
  <p>So basically, I need to grab the name of table B, find the row in Table A that has the matching 'Name' column, grab the ID and add it to the empty ID column in Table B</p>