求助sql语句

[cofeilover]

select distinct topics.name,initurl.title,initurl.url,site,page=count(docid) from topics
left join initurl on topics.id = initurl.topicid
left join pagerepository on initurl.urlid=pagerepository.sourceid
where id in (select distinct id from zhuanti where zu = 136)
group by topics.name,initurl.title,initurl.url, pagerepository.site
order by topics.name,initurl.title,initurl.url, pagerepository.site

俺这条查询有重复，问大家是在那里出错了啊？

[cofeilover]

谢谢了啊 感动的哇哇的了

[早起晚睡]

select distinct a.name,b.title,b.url,site,page=count(docid) from topics a
left join initurl b on topics.id = initurl.topicid
left join pagerepository c on b.urlid=c.sourceid
where id in (select distinct id from zhuanti where zu = 136)
group by a.name,b.title,b.url, c.site
order by a.name,b.title,b.url, c.site
我给你简化了一下
你还是说清楚一些就这些语句怎么知道他们之间的关系什么的

[早起晚睡]

select distinct a.name,b.title,b.url,site,page=count(docid) from topics a
left join initurl b on a.id = b.topicid
left join pagerepository c on b.urlid=c.sourceid
where id in (select distinct id from zhuanti where zu = 136)
group by a.name,b.title,b.url, c.site
order by a.name,b.title,b.url, c.site