根据路线分类查找该分类下热门(点击量高的)路线信息的两种方式

 

--根据路线分类查找该分类下热门(点击量高的)路线信息的两种方式

select top 10 * from Tab_TouristTrack tt,Tab_touristTrackCategory tc
where tt.routeCategory=tc.id and routeParent=1 order by click desc,id desc


select top 10 *  from Tab_TouristTrack
where routeCategory in (select id from Tab_touristTrackCategory 
where routeParent=1 
)order by click desc,id desc