Hello Raphael

>update subcust
set ccustcode = customer.ccustcode
from subcust, customer
where subcust.customerkey = customer.customerkey

I tried this earlier today and same-difference. You get exactly the same result as when using the JOIN as it is functionally the same.

Thanks for suggesting this though :)

Angie.