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.