22,209
社区成员
发帖
与我相关
我的任务
分享
select t1.*,t2.*
from 图1 t1
inner join 图2 t2
on ',' + t1.CHECKIPS + ',' LIKE '%,' + T2.IPADDR + ',%'
select t1.*,t2.*
from 图1 t1
inner join 图2 t2
on ',' || t1.CHECKIPS || ',' LIKE '%,' || T2.IPADDR || ',%'
select t1.*,t2.*
from 图1 t1
inner join 图2 t2
on ',' || t1.CHECKIPS || ',' LIKE '%,' || T2.IPADDR || ',%'