title: multi part identifier can't be bound in an update query
body: <p>I need to update a table with info from a different table using both tables as the condition</p>
  
  <pre><code>UPDATE prod
  SET prod.sale=change.price
  WHERE prod.sku=change.sku AND prod.isonsale=0;
  </code></pre>
  
  <p>Seems straight forward but I keep getting a multi part identifier can't be bound error, looking it up there's a lot of join statements flying about, but not a lot of explanation,  can someone tell me why this isn't working and maybe how to fix it?</p>
  
  <p>Thanks!</p>