/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

13 votes273 views4 answers
Sql joining 3 tables
SQL
0 vote194 views1 answer
Mysql get nested records
SQL
2 votes126 views1 answer
Match in sql server
SQL
0 vote130 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote201 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote122 views1 answer
Nested if in mysql
SQL
3 votes141 views2 answers
How to start postgresql on windows
SQL
4 votes163 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
1 vote132 views1 answer
Sql where max date
SQL
9 votes147 views4 answers
Last mysql
SQL

Share