求助--关于Select筛选重复的查询结果……

[ckxp]

语句是这样写的：
SELECT TOP 10 u.NetName，u.UserName FROM diaryUser u INNER JOIN diaryData d ON d.UserID=u.UserID ORDER BY d.DiaryID DESC

结果是这样的：

药师琉璃光
药师琉璃光
药师琉璃光
淼渺
彼岸花
卡卡柠檬
乱．暮沄春澍
乱．暮沄春澍
乱．暮沄春澍
乱．暮沄春澍

有什么方法可以不重复显示，跳过去继续查询吗？

[思源6DZ]

select top 10 u.NetName, u.UserName from diaryUser u,diaryData d where d.UserID=u.UserID order by d.DiaryID desc

[ckxp]

有人帮解答吗？

[reaperwu]

select top 10 * from (select distinct
u.NetName, u.UserName from diaryUser u,diaryData d where d.UserID=u.UserID) as temp order by DiaryID desc

[reaperwu]

错了，
select top 10 * from (select distinct d.DiaryID, u.NetName, u.UserName from diaryUser u,diaryData d where d.UserID=u.UserID) as temp order by DiaryID desc

[dishui]

考虑用distinct，不过这里写的我总觉得可能回出错，他有可能对id distinct了，可是并没对name distinct了

[reaperwu]

dishui(滴水藏海) 说的对，当初没有考虑清楚
select top 10 * from (select distinct u.NetName, u.UserName from diaryUser u,diaryData d where d.UserID = u.UserID order by DiaryID desc) as temp