[SQL ] JOIN遇到的問題
我是用 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
推
01/06 08:30, , 1F
01/06 08:30, 1F
推
01/06 18:17, , 2F
01/06 18:17, 2F
→
01/06 21:34, , 3F
01/06 21:34, 3F
討論串 (同標題文章)
Database 近期熱門文章
PTT數位生活區 即時熱門文章