Answers for "sql join two table and update value of column in one to the value of column in joined table"

SQL
5

inner join update

UPDATE 
    t1
SET 
    t1.c1 = t2.c2,
    t1.c2 = expression,
    ...   
FROM 
    t1
    [INNER | LEFT] JOIN t2 ON join_predicate
WHERE 
    where_predicate;
Posted by: Guest on September-11-2020

Code answers related to "sql join two table and update value of column in one to the value of column in joined table"

Code answers related to "SQL"

Browse Popular Code Answers by Language