How to Update Table A column 3 with input from Table B column 3 Teradata-CodePudding

Attached is my solution but it shows error expect something between column3 and from

update table_A
set table_A.column3 = table_B.column3 
from table_A
join table_B on (table_A.column1 = table_B.column1 and
                 table_A.column2 = table_B.column2);

CodePudding user response：

Update requires implicit join syntax:

update table_A
from table_A, table_B
set table_A.column3 = table_B.column3 
where (table_A.column1 = table_B.column1 and
       table_A.column2 = table_B.column2);

I fixed the order of keywords, too.