求一条SQL语句,较复杂百分相送

Question

本帖最后由 acelove 于 2012-11-29 13:51:07 编辑

Answer 1

select distinct b.* from a,b where charindex(','+a.KEYWORDS+',',','+b.KEYWORDS+',')>0

Answer 2

select distinct b.*
from TAB_A a
join TAB_B b on charindex(','+ltrim(a.KEYWORDS)+',',','+b.KEYWRODS+',')>0

Answer 3

select * from TAB_B
 where exists(select 1 from TAB_A where ','+TAB_B.KEYWRODS+',' like '%,'+KEYWORDS+',%')

Answer 4

select distinct b.* from a,b where charindex(','+a.KEYWORDS+',',','+b.KEYWORDS+',')>0