update dateia set feld=wert
where artnra in (select artnrb from dateib where statusb='XX' and ...)