/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 vote162 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
14 votes173 views5 answers
Set password for postgres user ubuntu
SQL
0 vote191 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote194 views1 answer
Postgresql can you have null foreign key
SQL
0 vote186 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote233 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote157 views1 answer
How to Remove milliseconds from Date time
SQL
8 votes196 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote252 views1 answer
Trigger
SQL
0 vote176 views1 answer
Raiserror with nowait
SQL

Share