Access sql join with wildcard code example
Example 1: sql join on wildcard
select *
from tableA a
where exists (select 1 from tableB b where a.id like '%' + b.id + '%');
Example 2: sql join on wildcard
select *
from tableA a join
tableB b
on a.id like '%' + b.id + '%';