You will have to use something like this if you are updating table_A from table_B in redshift.

update schema.table_A
set new_var = schema.table_B.new_var
from schema.table_B
where schema.table_A.record_id = schema.table_B.record_id