/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

0 vote267 views1 answer
Postgres where
SQL
0 vote292 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote300 views1 answer
Move table to a different schema
SQL
3 votes372 views1 answer
Oracle cannot access v$session
SQL
0 vote283 views1 answer
Sql date between one week
SQL
1 vote257 views1 answer
Input in mysql
SQL
3 votes448 views6 answers
Sql unique select
SQL
0 vote287 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote259 views1 answer
Replace sqlalchemy
SQL
2 votes289 views1 answer
Sql percentage with % rounded down
SQL

Share