如果您在表2的文本列中有通配符表达式,则可以这样做。
select *
from Table1 as T1
where exists (select *
from Table2 as T2
where T1.[text] like T2.[text])
select *
from Table1 as T1
where exists (select *
from Table2 as T2
where T1.[text] like '%'+T2.[text]+'%')