谁会写此sql语句？

作者: xiakai4640256   发布时间: 2011-11-04

;with cte as(
select channel_id,news_id,channel_fid from et_channel
union all
select b.channel_id,b.news_id,b.channel_fid from cte a inner join et_channel b on a.channel_fid=b.channel_id
)select news_id from cte

作者: qianjin036a   发布时间: 2011-11-04

;with cte as(
select channel_id,news_id,channel_fid from et_channel where title='当前频道标题'
union all
select b.channel_id,b.news_id,b.channel_fid from cte a inner join et_channel b on a.channel_fid=b.channel_id
)select news_id from cte

作者: qianjin036a   发布时间: 2011-11-04

作者: geniuswjt   发布时间: 2011-11-04

作者: xiakai4640256   发布时间: 2011-11-04

作者: stublue   发布时间: 2011-11-04