22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM A
LEFT JOIN B ON B.segment2 IN A.segment1
SELECT *
FROM A
LEFT JOIN B ON CHARINDEX(','''+B.segment2+''',', ','+A.segment1+',')>0
SELECT *
FROM A
LEFT JOIN B ON CHARINDEX(','+B.segment2+',', ','+A.segment1+',')>0