Joining tables with a like wildcard

[ciarra41]

I trying to join two tables with table a has a single value whereas the table b may have multiple values but still has the value in table a.

Possible easy fix?

select a.* FROM
tableA as a
inner join
tableB as b
on b.CODE = LIKE '%'[a.code]'%'

 

[r937]

ON b.CODE LIKE '%' + a.code + '%'

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[Qik3Coder]

And all together now:

Select a.*
FROM tableA a
JOIN tableB b ON
b.Code LIKE '%'+a.Code+'%'

Note this is expecting something like:
a.Code[tab]b.Code
AAA[tab]AAA BBB
AAA[tab]CCC DDD AAA
BBB[tab]EEE BBB DDD


Lodlaiden


You've got questions and source code. We want both!