/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 vote267 views1 answer
Select even number id data from table
SQL
31 votes275 views2 answers
Grant all priviledges to mysql user
SQL
0 vote319 views1 answer
Mysql streaming example
SQL
1 vote261 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote276 views1 answer
Mysql aspas simples
SQL
2 votes319 views1 answer
Create delete procedure mysql
SQL
0 vote258 views1 answer
Mysql return column names when table is empty
SQL
7 votes304 views3 answers
Sql update where id
SQL
0 vote291 views1 answer
Insert using condition postgres
SQL
3 votes253 views1 answer
Oracle undo tablespace list by user
SQL

Share