Sql

select *
from tableA a
where exists (select 1 from tableB b where  a.id like '%' + b.id + '%');

select *
from tableA a join
     tableB b
     on a.id like '%' + b.id + '%';

PREVIOUS	NEXT

Code Example
Sql :: java.sql.sqlexception: the url cannot be null
Sql :: sql where multiple values
Sql :: sql merge statement
Sql :: postgresql alter column data type from integer to integer array
Sql :: how to declare variable date in mysql
Sql :: postgres copy table
Sql :: flask sqlalchemy remove duplicates
Sql :: drop procedure postgres
Sql :: mysql copy row with new id
Sql :: oracle job schedules
Sql :: how to get the previous day on mysql
Sql :: mysql multiple left joins on same table
Sql :: pl sql command line run
Sql :: timestamp(0) postgresql
Sql :: sqlcmd
Sql :: sql server synonym
Sql :: mysql update LAST_INSERT_ID()
Sql :: how to modify alter user root@localhost identified with mysql_native_password by properly
Sql :: column must appear in the GROUP BY clause or be used in an aggregate function
Sql :: how to find 2nd highest salary in mysql
Sql :: how to insert multiple rows in mysql using laravel
Sql :: primary key with prefix sql
Sql :: what is common table expression in sql
Sql :: SELECT SQL LIKE
Sql :: where keyword sql
Sql :: alter in mysql
Sql :: SELECT statement to find the specific cell in database table
Sql :: cronjob mysql backup
Sql :: modularity meaning in plsql
Sql :: sql int +1