作者z77819 (Qoo离开合了)
看板Database
标题[SQL ] JOIN遇到的问题
时间Tue Jan 6 02:45:31 2009
我是用 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
1F：推 grence:这个设计…原po当成第一个回覆的人吗？ 01/06 08:30
2F：推 Antzzz:捞主题为什麽要去join post？ 01/06 18:17
3F：→ z77819:grence 你说的没错，但是在mysql为何可以，ms却不行？ 01/06 21:34