/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 vote124 views1 answer
Mssql check if date is greater than today
SQL
0 vote113 views1 answer
Android sqlite get rows count
SQL
-2 votes123 views1 answer
Modify column name in tsql
SQL
1 vote110 views2 answers
Postgresql list columns
SQL
0 vote141 views1 answer
Query to insert image
SQL
0 vote186 views1 answer
Sql to search who modified
SQL
13 votes106 views5 answers
Alter table query sql server change column
SQL
0 vote117 views1 answer
Uncomment listen_address=localhost
SQL
1 vote119 views1 answer
Mysql select utc time in eastern time
SQL
1 vote109 views1 answer
Regular expression in sql server
SQL

Share