Re: Doubt on a query

[Peter Brawley]

update Ficha_Cliente f 
join ( 
  select id_utente, max(data) as lastday 
  from Calendario 
  WHERE presente=1 
    AND activo=1 
    AND id_cliente=9263 
    AND data<='2021-02-21' 
  group by id_utente
) c on f.id=c.id_utente 
set f.ultima_presenca = c.lastday;