select * from bus_news_class c, bus_news_info i
where c.news_classid=i.news_classid
connect by c.news_parentid=c.news_classid
start with c.news_parentid=3
where c.news_classid=i.news_classid
connect by c.news_parentid=c.news_classid
start with c.news_parentid=3
order by c.news_parentid,c.news_classid
这个性能更好
select * from bus_news_info i
where exists(select 0 from bus_news_class c where c.news_classid=i.news_classid
connect by c.news_parentid=c.news_classid
start with c.news_parentid=3
)