一个小视图,不知怎么写,请教!
uuuuu 2003-10-09 04:44:12 我有两个表Forums_Topics和Forums_Replies都有时间和MemberID字段,要求取出最后回复人的ID怎么写?
取出最后回复时间的视图如下:
(SELECT MAX(AddedDate)
FROM (SELECT TopicID, AddedDate,MemberID
FROM Forums_Topics
UNION ALL
SELECT TopicID, AddedDate,MemberID
FROM Forums_Replies) AS dates
WHERE dates.TopicID = Forums_Topics.TopicID) AS LastPostDate
如果还要根据取出MemberID在Member表中取MemberName要怎么写?我想了好久,而且一定要在视图中实现!!头痛!