Hi Angie,
How about giving this a go...
UPDATE SubCust SET cCustCode = (SELECT cCustCode FROM Customer cu WHERE SubCust.CustomerKey = cu.CustomerKey)
>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.