Amazon web services – Proper syntax in redshift sql for "schema"."table"."field"?
I'm updating table_A with a variable, new_var, pulled in from table_B. Both table_A and table_B are in the same schema. alter table schema.table_A add column new_var varchar(3) update schema.table_A set schema.table_A.new_var = schema.table_B.new_var from schema.table_B where schema.table_A.record_id = schema.table_B.record_id However,…