/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 vote110 views1 answer
Low level operator in dbms
SQL
3 votes107 views1 answer
Oracle sleep
SQL
3 votes149 views1 answer
Oracle nextval insert
SQL
0 vote118 views1 answer
How to select even id in sql
SQL
0 vote114 views1 answer
Mysql query with sql to get the next row
SQL
0 vote103 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote115 views1 answer
Flush user resource mysql
SQL
0 vote167 views1 answer
Postgresql powershell query
SQL
0 vote118 views1 answer
Create table with float datatype in sql server
SQL
0 vote112 views1 answer
Limit and offset in stored procedure mssql
SQL

Share