>UPDATE mittellog SET ESTIM_ID = RV.ESTIM_ID, BILL_LOCAT = RV.BILL_LOCAT > FROM REVIEWERIDS RV, mittellog ML > where TRIM(ML.reviewerid) <> '' AND TRIM(ML.reviewerco) <> '' > AND ML.reviewerid = RV.reviewerid and ML.reviewerco = RV.reviewerco > and ML.estim_id not in (select estim_id from estimators)