Hello everyone,

I am trying to formulate some T-SQL to update a new column in a sub-customer table (cCustCode) with the value of cCustCode from its parent table. The parent table is called Customer and the child table is called SubCust. They are related at the moment using CustomerKey. I have tried the following SET statement but it only updates with a single value. What am I doing wrong :(

Also, can you use an alias for subcust (after the update statement) ?

update subcust
	set ccustcode = customer.ccustcode
	from subcust join customer
	on subcust.customerkey = customer.customerkey

Thank you so much!

Angie.