/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

-1 vote213 views1 answer
Capitole toulouse
SQL
3 votes234 views3 answers
Order by postgres
SQL
0 vote210 views1 answer
Postgresql in vs any performance
SQL
1 vote194 views1 answer
Sql restore backup query
SQL
16 votes191 views4 answers
Sort by sql
SQL
0 vote200 views1 answer
Mysql a from on this page has
SQL
0 vote302 views3 answers
CONTACT FORM SQL
SQL
22 votes179 views2 answers
Mysql show all tables
SQL
1 vote224 views1 answer
Oracle drop temporary table
SQL
18 votes192 views4 answers
Foreign key mySql
SQL

Share