Sergey,

Is next preferrable

UPDATE v_zips ;
SET dealerid = zips.dealerid ;
FROM v_zips ;
JOIN zips ON zips.zipcode == v_zips.zipcode

than

* set order to 0 && ??
replace v_zips.dealerid WITH zips.dealerid ;
FOR v_zips.zipcode == zips.zipcode IN v_zips

I have never use UPDATE, I just and just even rember such of command! But is there an advantage to use it - I dont know.

AT