title: Need to populate a column based on another column in another table
body: <p>I'm probably overthinking this so here goes.</p>
  
  <p>I have two tables. The first one I want to populate the CorporationId based off it's TokenId value.</p>
  
  <p>dbo.UsersAccountLink:</p>
  
  <p><a href="https://i.stack.imgur.com/LS5Uc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LS5Uc.png" alt="enter image description here"></a></p>
  
  <p>And the table that I want to get the value from:</p>
  
  <p>Company.Token:</p>
  
  <p><a href="https://i.stack.imgur.com/AgG6y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AgG6y.png" alt="enter image description here"></a></p>
  
  <p>Here is what I have but it's not set right so it will not run. I'm not sure how to do this:</p>
  
  <pre><code>INSERT INTO dbo.UsersAccountLink.CorporationId
  Select CorporationId 
  From Company.Token
  Where Company.Token.TokenId = dbo.UsersAccountLink.TokenId
  </code></pre>
  
  <p>I want to populate dbo.UsersAccountLink.CorporationId with the value in Company.Token.CorporationId based on the TokenId.</p>
  
  <p>Help?!</p>