title: The Multi-part identifier could not bound
body: <p>I've read the other posts on this issue and I haven't really found one that receives this error from the situation I have.</p>
  
  <p>For the following query:</p>
  
  <pre><code>INSERT INTO dbo.EightIDs (Email)
      SELECT Email
      FROM dbo.TempTransferTable
      WHERE dbo.TempTransferTable.EightID = dbo.EightIDs.EID
  </code></pre>
  
  <p>I receive an error</p>
  
  <blockquote>
    <p>Multi-part identifier could not be bound</p>
  </blockquote>
  
  <p>on the <code>dbo.EightIDs.EID</code> part of the query. I'm not sure why it's giving me a problem when I'm basically just trying to match the IDs in one table with the IDs in a second table, then bring over the Emails accordingly.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Based on the comments about using <code>UPDATE</code> with a <code>JOIN</code>, here's what I came up with. Does this seem more appropriate?</p>
  
  <pre><code>UPDATE tbl1
  SET tbl1.Email = tbl2.Email
  FROM dbo.EightIDs tbl1
  JOIN dbo.TempTransferTable tbl2 ON tbl2.EightID = tbl1.EID
  </code></pre>