select distinct sno
from sp a
where not exists
( select *
from sp b
where sno='168' and not exists
( select *
from sp c
where sno=a.sno and pno=b.pno
)
)
from sp a
where not exists
( select *
from sp b
where sno='168' and not exists
( select *
from sp c
where sno=a.sno and pno=b.pno
)
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货