UPDATE partner SET fizetesi_hat_ido = 0 WHERE kod in (SELECT kod FROM partner WHERE fizetesi_hat_ido <> 0 AND fizetesmod in (SELECT kod FROM fizetesmod WHERE halasztott_fizetesu = 0));