create table #a (Perid int,depid int)
create table #b (depid int,depcode char(10))
insert #a values(1, 1)
insert #a values(2, 2)
insert #a values(3, 2)
insert #a values(4, 3)insert #b values(1, '01')
insert #b values(2, '0101')
insert #b values(3, '02')
select a.PerID from #a a,#b b
where a.depid=b.depid
and b.depcode like (
select rtrim(DepCode) + '%' from #b where DepID=1)结果:PerID
-----------
1
2
3 (3 row(s) affected)
create table #b (depid int,depcode char(10))
insert #a values(1, 1)
insert #a values(2, 2)
insert #a values(3, 2)
insert #a values(4, 3)insert #b values(1, '01')
insert #b values(2, '0101')
insert #b values(3, '02')
select a.PerID from #a a,#b b
where a.depid=b.depid
and b.depcode like (
select rtrim(DepCode) + '%' from #b where DepID=1)结果:PerID
-----------
1
2
3 (3 row(s) affected)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货