Answers for "how to use join in update query"

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 use join in update query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to use join in update query"

Code answers related to "how to use join in update query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to use join in update query"

Code answers related to "how to use join in update query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us