is there anysql equivalent to inner join ins on ins.address like '%a%'

[kkshansid]

SELECT [TOWN].*, institute.addre ss
FROM [TOWN] inner join institute on institute.addre ss like '%[TOWN].town%'

[nbiswas]

Answer to is there anysql equivalent to inner join ins on ins.address like '%a%'

Instead of like

'%[TOWN].town%'

try

like '%' + [TOWN].town + '%'

e.g.

Let's create some sample data

declare @town table(tid int, tname varchar(50))
declare @institute table(tid int,address varchar(50))


insert into @town 
	select 1,'town1' union all select 2,'town2' union all
	select 3,'town3' union all select 4,'town4' 
insert into @institute 
	select 1,'town1 address1' union all select 1, 'town1 address2' union all
	select 2,'town2 address3' union all select 3, 'town3 address4' union all
	select 4,'town4 address5' union all select 4, 'address6'

Query:

select t.*,i.address
from @town t
inner join @institute i
on t.tid = i.tid 
where i.address [B]like '%' + t.tname + '%'[/B]

Output:

tid	tname	address
1	town1	town1 address1
1	town1	town1 address2
2	town2	town2 address3
3	town3	town3 address4
4	town4	town4 address5

Hope this helps