/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 vote271 views1 answer
Top frequency in sql server
SQL
0 vote259 views1 answer
Denormalise SQL command
SQL
0 vote279 views1 answer
Insert ip address in mysql
SQL
15 votes265 views2 answers
Select Options
SQL
13 votes254 views2 answers
Oracle inner join
SQL
14 votes274 views3 answers
Oracle sql limit results
SQL
26 votes270 views2 answers
Mysql workbench download
SQL
0 vote312 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote303 views1 answer
How to compile a function in oracle
SQL
0 vote271 views1 answer
Sql server select value large text
SQL

Share