/SQL/Update with inner join postgres

Update with inner join postgres

Update with inner join postgres

update xtable x 
set col1 = y.col1
from ytable y 
where y.x_id = x.id;

3

Mysql update with join

UPDATE T1, T2,
[INNER JOIN | LEFT JOIN] T1 ON T1.C1 = T2. C1
SET T1.C2 = T2.C2, 
    T2.C3 = expr
WHERE condition

3

Sql join on wildcard

select *
from tableA a join
     tableB b
     on a.id like '%' + b.id + '%';

0

Source: stackoverflow.com

Similar codes

0 vote228 views1 answer
Call function sql oracle
SQL
4 votes236 views2 answers
REST API
SQL
0 vote228 views1 answer
Update one column from another column in same table
SQL
12 votes233 views2 answers
Delete all nodes neo4j
SQL
1 vote226 views2 answers
Sql groub by count
SQL
0 vote235 views1 answer
How to get data between a last week in mysql
SQL
0 vote254 views1 answer
Add mysql database to power bi web
SQL
0 vote242 views1 answer
Oracle current timestamp
SQL
1 vote240 views1 answer
Create new table in SQL from old table with data
SQL
1 vote290 views1 answer
Drop colum oracle 18c
SQL

Share