--是有点问题!distinct 后不用括号 create proc spGetLWordInfo @HostID int as select distinct VisiterID into #CommentDetail from Comments where HostID=@HostID order by CID desc select UserTable.UserName ,UserTable.Sex ,UserTable.Age ,UserTable.CityArea , UserTable.StudyLevel ,UserTable.TechnicalPost,UserTable.UserID from UserTable where UserID in (select #CommentDetail.VisiterID from #CommentDetail)
--是有点问题!distinct 后不用括号
create proc spGetLWordInfo
@HostID int
as
select distinct VisiterID into #CommentDetail from Comments
where HostID=@HostID order by CID desc
select UserTable.UserName ,UserTable.Sex ,UserTable.Age ,UserTable.CityArea ,
UserTable.StudyLevel ,UserTable.TechnicalPost,UserTable.UserID
from UserTable where UserID in (select #CommentDetail.VisiterID from #CommentDetail)