/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 vote105 views2 answers
Postgresql display subquery as json
SQL
0 vote136 views1 answer
Check for directory in bash
SQL
8 votes136 views1 answer
Mac restore mysql database command line
SQL
1 vote121 views2 answers
Group_concat limit mysql
SQL
6 votes129 views3 answers
Check if string contains substring sql
SQL
0 vote147 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote117 views1 answer
Customer using hdfc bank sql query
SQL
1 vote127 views1 answer
Oracle duration between timestamps
SQL
2 votes138 views2 answers
Postgres timestamp to datetime
SQL
1 vote128 views1 answer
Select random sample sql
SQL

Share