Join update query in sql

UPDATE A
SET foo = B.bar
FROM TableA A
JOIN TableB B
    ON A.col1 = B.colx
WHERE ...

Joins in update query

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

Similar codes

58 votes668 views6 answers
Create new user in postgres
SQL
5 votes347 views1 answer
Oracle scan source ddl
SQL
0 vote314 views1 answer
Now() -1 mysql
SQL
0 vote353 views1 answer
Optimize sql query
SQL
-1 vote317 views1 answer
Plsql while
SQL
0 vote364 views1 answer
Django how to get query result count
SQL
23 votes365 views3 answers
Mysqldump
SQL
8 votes353 views3 answers
Mysql alter table add index
SQL
16 votes386 views5 answers
Select last row in sql
SQL
3 votes370 views2 answers
How to list columns for particular tables in postgresql
SQL