/SQL/Sql join on wildcard

Sql join on wildcard

Sql join on wildcard

select *
from tableA a
where exists (select 1 from tableB b where  a.id like '%' + b.id + '%');

0

Source: stackoverflow.com

Sql join on wildcard

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

0

Source: stackoverflow.com

Similar codes

0 vote133 views1 answer
Sparql list all graphs
SQL
1 vote134 views1 answer
Does insert into overwrite sql
SQL
28 votes167 views6 answers
Foreign key
SQL
0 vote130 views1 answer
Systemverilog unique constraint unique values
SQL
2 votes192 views2 answers
How to DROP a table in mysql
SQL
0 vote132 views1 answer
Connect by query in oracle
SQL
0 vote131 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote131 views1 answer
Mysql root permission denied lost
SQL
0 vote123 views2 answers
Create sequence if not exists postgres
SQL
16 votes119 views1 answer
Mysql mediumint max value
SQL

Share