/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 vote313 views1 answer
Mysql loop through databases and execute query
SQL
0 vote300 views1 answer
Sql server udf performance
SQL
-1 vote298 views1 answer
How to check table exists or not in postgresql
SQL
0 vote307 views1 answer
Db format in quotation
SQL
0 vote322 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote307 views1 answer
Exec procedure oracle
SQL
1 vote316 views1 answer
Postgresql export output table as a csv
SQL
-1 vote323 views1 answer
Auto increment psql not primary key
SQL
21 votes302 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote316 views1 answer
Bidirectional outer join sql
SQL

Share