Does T-SQL allow

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

I find that often "join" trips me up with the outer/inner business.