Answers for "Access sql join with wildcard"

SQL
0

sql join on wildcard

select *
from tableA a
where exists (select 1 from tableB b where  a.id like '%' + b.id + '%');
Posted by: Guest on May-17-2020
0

sql join on wildcard

select *
from tableA a join
     tableB b
     on a.id like '%' + b.id + '%';
Posted by: Guest on May-17-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language