/SQL/Join update query in sql

Join update query in sql

Join update query in sql

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

2

Source: stackoverflow.com

Joins in update query

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

0

Similar codes

0 vote244 views1 answer
Renommer base sql
SQL
0 vote228 views1 answer
Cannot start database server xampp mac os
SQL
0 vote227 views1 answer
How to use lower case in mysql
SQL
1 vote228 views1 answer
Postgresql datetrunc too slow
SQL
5 votes238 views1 answer
Sysdate in oracle sql
SQL
0 vote193 views1 answer
Check id exist or not in sql
SQL
20 votes228 views2 answers
Counting in sql
SQL
0 vote230 views1 answer
Sql beginning of previous month
SQL
3 votes229 views1 answer
Ms sql skip take
SQL
1 vote240 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL

Share