Joins in update query

How to add where command in update comand with joins

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

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

Similar codes

0 vote351 views1 answer
/usr/bin/mandb: fopen /var/cache/man/7935: Permission denied
C
0 vote367 views1 answer
Homeworld 3
C
0 vote355 views1 answer
Magic Square matrix
C
5 votes370 views5 answers
Kubernetes cheat sheet
C
1 vote409 views2 answers
C sleep milliseconds
C
1 vote389 views1 answer
Modulation
C
1 vote503 views2 answers
Redis
C
0 vote351 views1 answer
Jock cranley
C
0 vote429 views1 answer
Limit axis in one direction plt
C
1 vote383 views1 answer
Create postgresql dump database mac
C