随笔-多表sql查询例子
select j.channel_id,k.content_id,ext.title,k.channel_path,e.title_img,e.channel_name,ext.release_datefrom(
select a.parent_id,a.channel_path,b.content_id from jc_channela
right join (select kk.* from jc_content kkleft join jc_content_ext ccon kk.content_id=cc.content_id
where model_id=10 group bykk.channel_id order bycc.release_date desc ) bon a.channel_id=b.channel_id
where a.parent_id !=753 )k
left joinjc_channelj
onj.channel_id=k.parent_id
left join jc_channel_ext e
on j.channel_id=e.channel_id
left join jc_content_ext ext
on k.content_id=ext.content_id
where j.parent_id=682
group by j.channel_id
//////////////////////////////////////////////////////////
select a.parent_id,a.channel_path,b.content_id from jc_channela
right join (select kk.* from jc_content kkleft join jc_content_ext ccon kk.content_id=cc.content_id
where model_id=10 group bykk.channel_id order bycc.release_date desc ) bon a.channel_id=b.channel_id
where a.parent_id !=753 这个是文章内容按照channel_id进行分组，取出每个栏目的一篇文章
页:
[1]