/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 vote143 views1 answer
How to find database collation in postgres
SQL
0 vote181 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote129 views1 answer
How to change null display in psql
SQL
1 vote289 views1 answer
Postgres convert text to number
SQL
1 vote159 views1 answer
Check current sequence value postgres
SQL
0 vote139 views1 answer
Sql sort ages
SQL
4 votes143 views1 answer
Wilayah indonesia database
SQL
0 vote153 views1 answer
Mysql backup query
SQL
0 vote153 views2 answers
Unique key
SQL
2 votes141 views2 answers
Postgresql get table names
SQL

Share