[SQL ] JOIN遇到的問題

[z77819 (Qoo離開合了)]

我是用 Microsoft SQL Server 2005,

資料庫有建兩張 Table,

EIP_Forum_Thread(ThreadID, ForumID, title, ViewCount)

EIP_Forum_Posts(PostID, ThreadID, body, AddedDate, AddedBy)

Thread存主題, Posts存回覆的資料

我想要做 JOIN 撈出某個版所有主題


我的SQL指令

SELECT DISTINCT EIP_Forum_Posts.ThreadID, EIP_Forum_Thread.title,
                EIP_Forum_Thread.ViewCount, EIP_Forum_Posts.AddedDate,
                EIP_Forum_Posts.AddedBy

FROM EIP_Forum_Posts INNER JOIN EIP_Forum_Thread ON
     EIP_Forum_Posts.ThreadID = EIP_Forum_Thread.ThreadID

WHERE (EIP_Forum_Thread.ForumID = @fid)


如果文章沒人回覆就沒有問題，可是有的話就會連回覆的文章標題一起出來

請問該怎麼修改OK??


一開始是想用Group by去做，可是沒辦法執行，不過在MY SQL卻可以

我的SQL指令~

SELECT *

FROM EIP_Forum_Posts INNER JOIN EIP_Forum_Thread ON
     EIP_Forum_Posts.ThreadID = EIP_Forum_Thread.ThreadID

WHERE (EIP_Forum_Thread.ForumID = @fid)

GROUP BY EIP_Forum_Thread.ThreadID


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 140.127.149.105
推 grence:這個設計…原po當成第一個回覆的人嗎？
推 Antzzz:撈主題為什麼要去join post？
→ z77819:grence 你說的沒錯，但是在mysql為何可以，ms卻不行？