Answers for "how to update table with join in sql"

update with join

UPDATE
        first_table ft
        JOIN second_table st ON st.some_id = ft.some_id
        JOIN third_table tt  ON tt.some_id = st.some_id
        .....
    SET
        ft.some_column = some_value
    WHERE ft.some_column = 123456 AND st.some_column = 123456

Posted by: Guest on January-21-2021

joins in update query

update a
join b 
on a.a_id=b.b_id 
set b.is_active = 1 
where ....;

Posted by: Guest on January-20-2021

Code answers related to "how to update table with join in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to update table with join in sql"

Code answers related to "how to update table with join in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to update table with join in sql"

Code answers related to "how to update table with join in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us