sql join on wildcard

Solutions on MaxInterview for sql join on wildcard by the best coders in the world

Search
showing results for - "sql join on wildcard"
Abril
13 Jun 2020
1select *
2from tableA a
3where exists (select 1 from tableB b where  a.id like '%' + b.id + '%');
source
Lou-Anne
03 Jan 2018
1select *
2from tableA a join
3     tableB b
4     on a.id like '%' + b.id + '%';
source
similar questions
oracle wildcardjoin in sql serverfull join sqlright join sqlonly join in sqlsql left joinupdate with join sql serverhow to join three tables in sql using joinsequi joins in oraclesql server like wildcardms sql left join selectsql server joinsoracle sql wildcard likesql query for getting data with join and countsql right joinjoins in sql serverwildcard in sqlnatural join sqlbidirectional outer join sqljoins and views sql
queries leading to this page
wildcard sql column on joinsql join with wildcardaccess sql join with wildcardwhat is equi join in sqlupdate with inner join postgressql join like wildcardcan you use a wild card to join tables insqljoining tables based on wildcardsql join on wildcard