title: the multi part identifier could not be bound while using UPDATE query
body: <p>I am trying to update email address from table <code>B_A</code> to table <code>A</code> if email address is different in table <code>B_A</code> is different from table <code>A</code>.</p>
  
  <p>the query I am trying is :</p>
  
  <pre><code>UPDATE A
  SET Email = ( select [Email Address] from [B_A] where A.Email &lt;&gt; [B_A].[Email_Address])
  where A.ID = [B_A].[ID]
  </code></pre>
  
  <p>and my error is : 
  <code>the multi part identifier [B_A].[ID] could not be bound</code></p>
  
  <p>how do I normalize this query to run?</p>