select 帖子标题=b.title,
帖子作者=a.name,
帖子最后回复日期=b.LastReplyDate,
帖子最后回复人=a1.name
from NetLog_Member a,NetLog_Member a1,NetLog_ForumMotif b
where a.id=b.PostMemberID
and a1.id=b.LastReplyMemberID
and not exists(
select * from NetLog_ForumMotif where id=b.id and LastReplyDate>b.LastReplyDate)
NetLog_ForumMotif.LastReplyDate as 帖子最后回复日期,NetLog_Member.MemberName as 帖子最后回复人
from NetLog_ForumMoti,NetLog_Membe where NetLog_ForumMot.LastReplyMemberID=NetLog_Member.MemberId(用户ID)
from motif m inner join member n on m.postmemberid=n.id
inner join member s on m.lastreplydate=s.id
(select name from member where mo.PostMemberID=id) as 帖子作者 ,
mo.LastReplyDate as 帖子最后回复日期,
(select name from member where mo.LastReplyID=id) as 帖子最后回复人
from motif as mo
不好意思哦
你的是錯的。如再加一條的記錄的話就錯的﹔
id title PostMemberID LastReplyMemberID LastReplyDate
-- ----- ------------ ----------------- -------------
1 你好 1 2 2003.01.12 13:00:00
2 我好 2 3 2003.01.18 19:05:00
3 你好 1 2 2003.01.12 13:00:00
zjcxc(邹建) 試試你的方法看﹗