/SQL/Sqlite update from another table

Sqlite update from another table

Sqlite update from another table

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

Similar codes

0 vote264 views1 answer
Sqlalchemy get schema from database
SQL
0 vote245 views1 answer
Check duplicate values plsql
SQL
0 vote250 views1 answer
Assign value to var in SQL
SQL
0 vote250 views1 answer
Tsql cmd exec script from file
SQL
0 vote260 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
1 vote260 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote214 views0 answer
SQL
2 votes255 views2 answers
Postgres drop column if exists
SQL
5 votes282 views1 answer
Oracle drop index if exists
SQL
2 votes246 views1 answer
Mysql time ago difference
SQL

Share