高效sql-查出树形的层级关系
select b3.chinesename, b2.chinesename,b1.chinesename from business b1
inner join business b2 on b1.treeid=b2.treeid and b2.depth=2 and b1.lvalue BETWEEN b2.lvalue and b2.rvalue
inner join business b3 on b1.treeid=b3.treeid and b3.depth=1 and b2.lvalue BETWEEN b3.lvalue and b3.rvalue
where b1.depth=3 and b1.flag=1
inner join business b2 on b1.treeid=b2.treeid and b2.depth=2 and b1.lvalue BETWEEN b2.lvalue and b2.rvalue
inner join business b3 on b1.treeid=b3.treeid and b3.depth=1 and b2.lvalue BETWEEN b3.lvalue and b3.rvalue
where b1.depth=3 and b1.flag=1