UPDATE MOTESTDTA/TYP SET AUFA = 'blau', HAFA = 'blond'
WHERE size > 185
AND typ.kunr in
(select pers_inf.kunr from motestdta/pers_inf
where pers_inf.kunr = typ.kunr and dec(substr(polz, 1, 5)) < 40000)