Hi,

Kevin, thank for your help. At a first look, this SQL code look exactly what I need, but I'll have to do some test to be sure. I really appreciated your quickly answer.

Thx


>You can do this as one SQL statement:

>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)