22,209
社区成员
发帖
与我相关
我的任务
分享
--测试数据
;WITH 表A(ColA)AS(
select '015050' union all
select '020050' union all
select '025050'
),表B(ColB)AS(
select 'RN70M015050B00' union all
select 'RN75M015050B00' union all
select 'RN70M020050B00' union all
select 'RN80M020050B00' union all
select 'RN70M030060B00' union all
select 'RN70M040060B00' union all
select 'RN70M050060B00'
)
--测试数据结束
SELECT ColB
FROM 表B
WHERE EXISTS ( SELECT *
FROM 表A
WHERE 表B.ColB LIKE '%' + 表A.ColA + '%' )