title: Good way to use table alias in Update statement?
body: <p>Using SqlServer, and trying to update rows from within the same table. I want to use a table alias for readability.
  This is the way I am doing it at the moment:</p>
  <pre><code>UPDATE ra 
  SET ra.ItemValue = rb.ItemValue
  FROM dbo.Rates ra, dbo.Rates rb
  WHERE ra.ResourceID = rb.ResourceID
  AND ra.PriceSched = 't8'
  AND rb.PriceSched = 't9'
  </code></pre>
  <p>Are there easier / better ways?</p>