需要加()select b.id,a.nodeid,a.type,
case a.type
when 1 then (select areaname from area where area.areaid=a.nodeid)
when 2 then (select spotname from spot where spot.spotid=a.nodeid)
when 3 then (select channelname from channel where channel.channelid=a.nodeid)
end
from real a,getchild() b where a.realid=b.id order by b.sid
case a.type
when 1 then (select areaname from area where area.areaid=a.nodeid)
when 2 then (select spotname from spot where spot.spotid=a.nodeid)
when 3 then (select channelname from channel where channel.channelid=a.nodeid)
end
from real a,getchild() b where a.realid=b.id order by b.sid
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货