/SQL/Update join

Update join

How to add where command in update comand with joins

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

2

Source: stackoverflow.com

Update from select join

UPDATE t1
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
FROM MY_TABLE AS t1
JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
WHERE t1.COL3 = 'OK';

1

Update join

//mysql
UPDATE store_fars
        INNER JOIN
   fake ON store_fars.id = fake.id
SET 
    fake.id = store_fars.id

0

Similar codes

2 votes205 views1 answer
Where clause for child record apex
SQL
2 votes173 views2 answers
Get all columns from table sql
SQL
4 votes253 views3 answers
Postgres drop all tables
SQL
0 vote196 views1 answer
Sql cursor example multiple columns
SQL
0 vote180 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote187 views1 answer
Grepper sql workbench download
SQL
1 vote207 views2 answers
End mysql command
SQL
0 vote270 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote183 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote158 views1 answer
Mysql select top 2
SQL

Share