469,922 Members | 2,106 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,922 developers. It's quick & easy.

MS Access Sql Query

14
I have this query that produces Syntax Error(missing operator) in query operation ForumTopics.TopicID = ForumReply.TopicID LEFT OUTER JOIN
Members ON ForumTopics.WrittenBy = Members.Member_ID in MS Access


this is the query:
SELECT ForumTopics.TopicID, ForumTopics.TopicName, Members.FName, COUNT(ForumReply.ReplyID) AS Reply, MAX(ForumReply.ReplyDate) AS LastPost
FROM ForumTopics INNER JOIN
ForumReply ON ForumTopics.TopicID = ForumReply.TopicID LEFT OUTER JOIN
Members ON ForumTopics.WrittenBy = Members.Member_ID
GROUP BY ForumTopics.TopicID, ForumTopics.Topic, ForumTopics.CategoryID, Members.FName
HAVING (ForumTopics.CategoryID = 1)
order by LastPost desc;

What is missing in this query? Need Help please...
Jan 17 '07 #1
0 856

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Frnak McKenney | last post: by
1 post views Thread by Joris Kempen | last post: by
14 posts views Thread by Sean C. | last post: by
52 posts views Thread by Neil | last post: by
3 posts views Thread by mnjkahn via AccessMonster.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.