/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

2 votes337 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote320 views1 answer
How to create a new shema using query languaage
SQL
2 votes347 views2 answers
Mysql count rows returned
SQL
0 vote315 views1 answer
Sql fetch next 10 rows pdo
SQL
1 vote334 views1 answer
Oracle stop
SQL
0 vote347 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote347 views1 answer
Oracle last connexion
SQL
0 vote397 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote308 views2 answers
Oracle replace
SQL
0 vote336 views5 answers
How to make trigger in phpmyadmin
SQL

Share