Hi,

Dou You know better way or short syntax for query below:

(Without EXISTS, the query will set the region number to NULL)

update customer as c
set region =
(select newregion
from fixes
where oldregion = c.region)
where exists
(select *
from fixes
where oldregion = c.region)

Thanks,
Safak