/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

22 votes333 views3 answers
SQL CHEATSHEET
SQL
1 vote333 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote342 views1 answer
Get all employee of salary if more than in sql
SQL
5 votes327 views1 answer
Commentaire table oracle
SQL
4 votes347 views2 answers
Float postgres
SQL
0 vote324 views1 answer
Copy Table from SQL to CSV
SQL
0 vote333 views1 answer
Sintaxis SELECT sql
SQL
0 vote353 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote312 views1 answer
Create new table pl sql
SQL
0 vote302 views1 answer
How to get inserted id in sql server
SQL

Share