I take it that

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

didn't do the trick either.

I think then that the statements are running correctly and that you should inspect the data and structure in both table's customkey