• You really need to learn about books online.  Your UPDATE statement was totally wrong.


    UPDATE tv SET
    A = 1 - [tc].A
    , B = 1 - [tc].B
    , C = 1 - [tc].C
    , D = 1 - [tc].D
    FROM
    T_V AS tv
    INNER JOIN T_C AS tc
      ON tv.[Unique ID] = tc.[Unique ID];