title: Update a table with join?
body: <p>I am trying to update table A with data from table B.
  I thought I can do something like this</p>
  
  <pre><code>update A 
  set A.DISCOUNT = 3 
  from INVOICE_ITEMS A
  join ITEM_PRICE_QUNTITY B on A.ITEM_PRICE_NO = B.ID
  where A.INVOICE_ID = 33
  </code></pre>
  
  <p>but getting error
  SQL Message : -104
  Invalid token</p>
  
  <p>can anyone help me?</p>