一个sql查询问题

[hyjno9]

select top 3 Dv_User.UserName,Dv_User.UserFace,Dv_bbs1.Topic,Dv_bbs1.AnnounceID,Dv_bbs1.BoardID from Dv_User,Dv_bbs1 where Dv_bbs1.UserName=Dv_User.UserName and Dv_User.UserClass='金牌会员' order by Dv_User.UserId desc, Dv_bbs1.AnnounceID desc

现在取出来的东西 Dv_User.UserName 是由重复的，怎么让取出的数据把重复的 Dv_User.UserName 去掉呢？

[cxc3214]

select  top 3  Dv_User.UserName,Dv_User.UserFace,Dv_bbs1.Topic,Dv_bbs1.AnnounceID,Dv_bbs1.BoardID from Dv_User
inner join 
Dv_bbs1  
on
Dv_bbs1.UserName=Dv_User.UserName
 and 
Dv_User.UserClass='金牌会员' 

order by 
Dv_User.UserId desc, Dv_bbs1.AnnounceID desc 

[ACMAIN_CHM]

select top 3 
	uUserName,uUserFace,
	b.Topic,b.AnnounceID,b.BoardID 
from (Dv_User u inner join ( select UserName,max(AnnounceID) as m_AnnounceID Dv_bbs1 group by UserName) a
	on u.UserName=a.UserName )
	inner join Dv_bbs1 b on a.m_AnnounceID=b.AnnounceID
where u.UserClass='金牌会员' 
order by uUserId desc, b.AnnounceID desc 

[郭大侠_]

应该用 left join 吧

[Gis个人开发]

select distinet Dv_User.UserName top 3 Dv_User.UserName,Dv_User.UserFace,Dv_bbs1.Topic,Dv_bbs1.AnnounceID,Dv_bbs1.BoardID from Dv_User,Dv_bbs1 where Dv_bbs1.UserName=Dv_User.UserName and Dv_User.UserClass='金牌会员' order by Dv_User.UserId desc, Dv_bbs1.AnnounceID desc

这样就可以了..用distinet去出重复啊..

[hyjno9]

access 的数据库，有些语法不支持啊

[ACMAIN_CHM]

2楼的语句在ACCESS中可用啊。

[hyjno9]

sql 太复杂程序中实现了

[flylovejings]

 inner...join...on