Re: update inner join

[Peter Brawley]

Camel case table & column names will bite you if the db ever finds itself on Linux. Usually best to stick to lower case names.

Is this what you mean?

update temprevenue as t
join (
  select servno, sum (charge) as chargesum
  from records
  where left(recdate,4) = '2017' 
  group by servno
) as r using( servno )
set t.revenue = r.chargesum;