select a.name,b.name,c.bName,a.doorplate,
case a.homeTel when '10000000' then '21958563'
else a.homeTel
end as homeTel,
d.date from Peoples a,Communities b,Buildings c,Employments d where d.state='就业'and c.buildId=a.buildId and a.communityId=b.communityId and a.peopleId=d.peopleId
case a.homeTel when '10000000' then '21958563'
else a.homeTel
end as homeTel,
d.date from Peoples a,Communities b,Buildings c,Employments d where d.state='就业'and c.buildId=a.buildId and a.communityId=b.communityId and a.peopleId=d.peopleId
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货