Re: Doubt on a query

[Peter Brawley]

update fichaclientes f
join (
  select user_id, max(day) as lastday
  from calendar
  group by user_id
) c using(user_id)
set f.last_day = c.lastday;