update 
  day245stats 
set 
  rank=r.srank_today, 
  rating=r.rating_today
from
  rollingstats as r
where 
  r.serverid=day245stats.serverid 
 and
  r.playerid=day245stats.playerid