/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

1 vote113 views1 answer
Jooq convert using gbk
SQL
12 votes190 views4 answers
How to drop all tables in postgresql
SQL
0 vote127 views1 answer
My sql data file extention
SQL
0 vote119 views1 answer
Zerar auto increment mysql
SQL
0 vote134 views1 answer
Select even number id data from table
SQL
0 vote168 views1 answer
Cahnge column name apex oracle
SQL
0 vote121 views1 answer
Mysql export and import
SQL
0 vote127 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote125 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
6 votes116 views1 answer
Rank function in oracle with example
SQL

Share